Export (0) Print
Expand All

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:

  • DISP_POOL_XE_ENGINE

  • DISP_POOL_XE_SESSION

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.

Requires VIEW SERVER STATE permission on the server.

Community Additions

ADD
Show:
© 2014 Microsoft