Slow reports, slow transactions, and the internal team could not find why. In this case study, MAXDOP = 1 was quietly slowing down the entire business.
SQL in Sixty Seconds – CPU Threads and Uneven Workload
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 2022 – Degree of Parallelism (DOP) Feedback for Optimize Query Performance
SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).
Configuring Parallel Index Operations in SQL Server
MAXDOP limits supported parallel index operations without changing unrelated instance settings. I choose the ceiling from the maintenance workload.
SQL Server 2022 – Thread Management for Performance Improvement
I had a great discussion about Thread Management for Performance Improvement with my client, who recently hired me for Comprehensive Database Performance Health Check.