Comprehensive Database Performance Health Check. Let us figure out today a very simple and effective script for CPU Scheduler Waiting On Disk.
I heard an interesting comment from a client and that made me write a blog post. Their point was about table variables, temp tables, and parallel queries.
A very common question I often receive during Comprehensive Database Performance Health Check is what is the best value for Maximum Worker Threads.
We will see a quick SQL in Sixty Seconds video and scripts used in the video to change MAXDOP. Let us watch 3 Ways to Configure MAXDOP.
Last week, I had published 3 videos on CPU, Linux, and Shutdown. I received lots of good feedback on each of them and also got lots of questions.