Provides statistics for the activity of each currently configured worker process.
Enable the enable monitoring configuration parameter for this monitoring table to collect data.
The columns for monProcessWorkerThread are:
Name |
Datatype |
Attribute |
Description |
|---|---|---|---|
SPID |
smallint |
Session process identifier |
|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
KPID |
int |
Kernel process identifier |
|
ThreadsActive |
int |
Number of worker threads currently in use by the process |
|
MaxParallelDegree |
smallint |
The maximum degree of parallelism this task can use, which is set with the set parallel_degree option for the session, or the current Run Value for max parallel degree. |
|
MaxScanParallelDegree |
smallint |
The maximum degree of parallelism for scans this task can use, which is set with set scan_parallel_degree for the session, or if this is not set, the current Run Value for max scan parallel degree. |
|
ParallelQueries |
int |
Counter |
Total number of parallel queries performed by this process |
PlansAltered |
int |
Counter |
Number of plans altered from “optimal” for the process. Plans are altered if Adaptive Server has an insufficient number of worker threads available to execute the query with an optimal degree of parallelism. |
FamilyID |
int |
Null |
The spid of the parent process, if this is a worker process |
