sys.dm_os_dispatcher_pools (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns information about session dispatcher pools. Dispatcher pools are thread pools used by system components to perform background processing.

Note

To call this from Azure SQL Data Warehouse or Parallel Data Warehouse, use the name sys.dm_pdw_nodes_os_dispatcher_pools.

Column name Data type Description
dispatcher_pool_address varbinary(8) The address of the dispatcher pool. dispatcher_pool_address is unique. Is not nullable.
type nvarchar(256) The type of the dispatcher pool. Is not nullable. There are two types of dispatcher pools:

DISP_POOL_XE_ENGINE

DISP_POOL_XE_SESSION

Query the DMV for the full list
name nvarchar(256) The name of the dispatcher pool. Is not nullable.
dispatcher_count int The number of active dispatcher threads. Is not nullable.
dispatcher_ideal_count int The number of dispatcher threads that the dispatcher pool can grow to use. Is not nullable.
dispatcher_timeout_ms int The time, in milliseconds, that a dispatcher will wait for new work before exiting. Is not nullable.
dispatcher_waiting_count int The number of idle dispatcher threads. Is not nullable.
queue_length int The number of work items waiting to be handled by the dispatcher pool. Is not nullable.
pdw_node_id int Applies to: Azure SQL Data Warehouse, Parallel Data Warehouse

The identifier for the node that this distribution is on.

Permissions

On SQL Server, requires VIEW SERVER STATE permission.
On SQL Database Premium Tiers, requires the VIEW DATABASE STATE permission in the database. On SQL Database Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.

See Also