Product has been added to your cart.

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,…

To access this incredible, amazing content, you gotta get Mastering Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.

  1. Home
  3. SQL Server Training Classes by Brent Ozar
  5. Mastering Server Tuning with Wait Stats
  7. 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,...
To access this incredible, amazing content, you gotta get Mastering Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.