I got lots of responses to this blog and people wanted me to create a video for this topic. Here, I have a video for CPU Running 100%.
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.