When SQL Server executes a query in parallel, CPU threads often share the workload unevenly. Some handle a significant portion of the rows, while others manage much less.
SQL SERVER – Troubleshooting Non-Yielding Scheduler Issues
During the engagement, I encountered a critical issue related to non-yielding schedulers in their SQL Server environment.
SQL SERVER – Thread Pool Waits: Monitoring and Optimization
Thread pool waits management plays a vital role in maximizing the utilization of threads and ensuring the smooth execution of tasks.
SQL SERVER – CPU Scheduler Waiting On Disk
Comprehensive Database Performance Health Check. Let us figure out today a very simple and effective script for CPU Scheduler Waiting On Disk.
SQL SERVER – Threads Not Counted for Max Worker Threads
I had a very interesting situation where I had to find all the threads which are not counted for max worker threads in SQL Server. Let us see the script.
Best Value for Maximum Worker Threads – SQL in Sixty Seconds #170
A very common question I often receive during Comprehensive Database Performance Health Check is what is the best value for Maximum Worker Threads.
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.