Running Queries - Task Level Wait Type #1632
Description
Wait type information is currently returned from sys.dm_exec_requests. Usually this is OK, but queries can have many tasks with different wait types and the information from sys.dm_exec_requests doesn't always provide the full picture. sys.dm_os_waiting_tasks provides more granular waits at task level and might be worth incorporating into the running query capture. Capturing everything from this DMV is probably overkill but it would be useful to capture the top wait types/durations.