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. |
Permissions
Requires VIEW SERVER STATE permission on the server.