Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.