sys.dm_os_waiting_tasks (Transact-SQL)
Returns information about the wait queue of tasks that are waiting on some resource.
Column name |
Data type |
Description |
|---|---|---|
waiting_task_address |
varbinary(8) |
Address of the waiting task. |
session_id |
smallint |
ID of the session associated with the task. |
exec_context_id |
int |
ID of the execution context associated with the task. |
wait_duration_ms |
int |
Total wait time for this wait type, in milliseconds. This time is inclusive of signal_wait_time. |
wait_type |
nvarchar(60) |
Name of the wait type. |
resource_address |
varbinary(8) |
Address of the resource for which the task is waiting. |
blocking_task_address |
varbinary(8) |
Task that is currently holding this resource |
blocking_session_id |
smallint |
ID of the session that is blocking the request. If this column is NULL, the request is not blocked, or the session information of the blocking session is not available (or cannot be identified). -2 = The blocking resource is owned by an orphaned distributed transaction. -3 = The blocking resource is owned by a deferred recovery transaction. -4 = Session ID of the blocking latch owner could not be determined due to internal latch state transitions. |
blocking_exec_context_id |
int |
ID of the execution context of the blocking task. |
resource_description |
nvarchar(1024) |
Description of the resource that is being consumed. |
Permissions
Requires VIEW SERVER STATE permission on the server.