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 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. You can also get a quick, low cost health check with no phone time required.
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.”
I’m looking at dm_os_waiting_tasks here, I think.