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. [wpc_button]

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.