3.1 How to Fix Worker Thread Waits (THREADPOOL)

When you combine CPU-heavy queries, like the parallel ones we discussed in the SOS_SCHEDULER_YIELD module, with blocking storms, you get THREADPOOL. SQL Server runs out of worker threads to start new queries. This is our first “poison wait” to discuss & demo. When you’re experiencing a poison wait like this, the server feels locked up,…