This blog post is a follow-up a blog post in the series of the blog post I am writing for my most popular online class Practical Real World Performance Tuning with Brent Ozar. In this blog post, we will discuss how do I do class preparation and setup.
Practical Real World Performance Tuning – Fun and Reviews
Unless you are staying under the rock, you would be familiar with Practical Real World Performance Tuning course. This is the second part about behind the scene story. You can read my first part here – Practical Real World Performance Tuning – Before the Class Announced. In this part of the blog series let us discuss about the reviews we received for this classes and fun we have during the session.
Practical Real World Performance Tuning – Before the Class Announced
I recently completed delivering Practical Real World Performance Tuning for Brent Ozar Unlimited and it was great 3 days of delivery. Here are my thoughts about my entire experience and how everything worked out. Let us go on the journey to Behind the Scenes for Teaching Online Class.
SQL SERVER – Optimal Value Max Worker Threads
During Comprehensive Database Performance Health Check, one of the DBas asked what is the most optimal value for Max Worker Threads. The question was indeed asked when my customer looked at the value of Max Worker Threads in the Processor sections of the Server Property, they were really worried. The default value of the Max Worker Threads is always set to zero.
SQL SERVER – Performance Comparison IN vs OR
Some questions never get old and some question and I believe we will be discussing them for many more years in the future. Just other days, I received this question during my SQL Server Performance Tuning Practical Workshop. The question was about Performance Comparison IN vs OR. Though personally, I have answered this question quite a many times before, let us answer it once again, it never hurts to repeat the truth multiple times.
SQL SERVER – How to Fix CONVERT_IMPLICIT Warnings?
One of the biggest issues I see with at various of my customer who signed up at Comprehensive Database Performance Health Check, is about CONVERT_IMPLICIT. As soon as I demonstrate my customer that they are not getting performance due to CONVERT_IMPLICIT their next question is how can they fix the issue of CONVERT_IMPLICIT. In this single blog post, we will learn about how to find this issue and fix it as well.
SQL SERVER – Why Suddenly DBCC CHECKDB Running Very Slow?
Recently during Comprehensive Database Performance Health Check, I was asked a fascinating question. They wanted to know why suddenly their DBCC CHECKDB process started to run very very slow.