Returns server-wide statistics related to worker thread configuration and execution.
Enable the enable monitoring configuration parameter for this monitoring table to collect data.
The columns for monSysWorkerThread are:
Name |
Datatype |
Attributes |
Description |
---|---|---|---|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
ThreadsActive |
int |
Number of worker processes currently active |
|
TotalWorkerThreads |
int |
Maximum number of worker processes (configured by setting number of worker processes) |
|
HighWater |
int |
reset |
The maximum number of worker processes that have ever been in use |
ParallelQueries |
int |
Counter, reset |
Number of parallel queries attempted |
PlansAltered |
int |
Counter, reset |
Number of plans altered due to unavailable worker processes |
WorkerMemory |
int |
The amount of memory currently in use by worker processes |
|
TotalWorkerMemory |
int |
The amount of memory configured for use by worker processes |
|
WorkerMemoryHWM |
int |
reset |
The maximum amount of memory ever used by worker processes |
MaxParallelDegree |
int |
The maximum degree of parallelism that can be used: the current Run Value for max parallel degree configuration option |
|
MaxScanParallelDegree |
int |
The maximum degree of parallelism that can be used for a scan: the current Run Value for max scan parallel degree configuration option |