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. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment 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.