sys.dm_os_waiting_tasks
os #os#dmv
Description
Analytics Platform System (PDW) Returns information about the wait queue of tasks that are waiting on some resource. For more information about tasks, see the Thread and task architecture guide ID of the session associated with the task.
Syntax
blocking_task_address