Wait Types – THREADPOOL (27m)

This one is a poison wait: it means queries can’t even get enough worker threads in order to get started. When it strikes, it’ll feel like your SQL Server service is totally locked up – even though you can remote desktop into the server and it seems like it’s not working hard at all.

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