Returns server-wide statistics related to worker threads. Requires the enable monitoring configuration parameter to be enabled.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
ThreadsActive |
int |
Number of worker processes active |
|
TotalWorkerThreads |
int |
Configured maximum 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 that were attempted |
PlansAltered |
int |
counter, reset |
Number of plans altered due to worker processes not being available |
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 parameter |
|
MaxScanParallelDegree |
int |
The maximum degree of parallelism that can be for a scan (the current Run Value for max scan parallel degree configuration parameter |
