During the engagement, I encountered a critical issue related to non-yielding schedulers in their SQL Server environment.
Thread pool waits management plays a vital role in maximizing the utilization of threads and ensuring the smooth execution of tasks.
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.
A very common question I often receive during Comprehensive Database Performance Health Check is what is the best value for Maximum Worker Threads.
I have an interesting experience to share about the Query Ignoring CPU Threads. I was hired by a large eCommerce organization.