sys.dm_os_waiting_tasks

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.

Release

History

5 December 2005

Term

Definition

**Changed content:**Expanded the description of the blocking_session_id column.