sys.dm_os_dispatcher_pools (Transact-SQL)
Returns information about session dispatcher pools. Dispatcher pools are thread pools used by system components to perform background processing.
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:
|
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. |
