| title | sys.dm_os_dispatcher_pools (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.dm_os_dispatcher_pools (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 02/27/2023 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | >=sql-server-2016||>=sql-server-linux-2017||>=aps-pdw-2016||=azure-sqldw-latest |
[!INCLUDE sql-asa-pdw]
Returns information about session dispatcher pools. Dispatcher pools are thread pools used by system components to perform background processing.
Note
To call this from [!INCLUDEssazuresynapse-md] or [!INCLUDEssPDW], use the name sys.dm_pdw_nodes_os_dispatcher_pools. [!INCLUDEsynapse-analytics-od-unsupported-syntax]
| 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: [!INCLUDEssazuresynapse-md], [!INCLUDEssPDW] The identifier for the node that this distribution is on. |
On [!INCLUDEssNoVersion_md] and SQL Managed Instance, requires VIEW SERVER STATE permission.
On SQL Database Basic, S0, and S1 service objectives, and for databases in elastic pools, the server admin account, the Microsoft Entra admin account, or membership in the ##MS_ServerStateReader## server role is required. On all other SQL Database service objectives, either the VIEW DATABASE STATE permission on the database, or membership in the ##MS_ServerStateReader## server role is required.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.