A very common question I often receive during Comprehensive Database Performance Health Check is what is the best value for Maximum Worker Threads.
3 Ways to Configure MAXDOP – SQL in Sixty Seconds #166
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.
CPU, Linux and Shutdown – 3 SQL in Sixty Seconds Video
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.
Get CPU Details – SQL in Sixty Seconds #164
I understand that there is no one way to describe the CPUs and that is the primary reason, why I get a different answer when I try to get CPU details.
SQL SERVER – AdHoc Queries and Optimize for Adhoc Workloads
Discussion with a client during the Comprehensive Database Performance Health Check. The topic is AdHoc Queries and Optimize for Adhoc Workloads.
SQL SERVER – Map SQL Server Session ID to OS Thread ID
He wanted to track the OS Thread ID in Performance Monitor. He asked me if I know any script which can Map SQL Server Session ID to OS Thread ID.
Find Expensive Queries – SQL in Sixty Seconds #159
Earlier I wrote a blog post about SQL SERVER – List Expensive Queries – Updated March 2021. Let us learn how to Find Expensive Queries.