Understanding SQL Server Hardware: Parallel Query Downgrade and THREADPOOL Waits

Parallel Query Downgrade and THREADPOOL Waits


Going Further


If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly.



2 thoughts on “Understanding SQL Server Hardware: Parallel Query Downgrade and THREADPOOL Waits

  1. Interesting that they get a row in sys.dm_exec_requests. Seems like the docs are inaccurate?

    ” session_id – ID of the session to which this request is related. Isn’t nullable.”

Comments are closed.