The metrics in this category provide server-wide statistics related to worker threads.
Collection Frequency - Every hour
Table 3-45 Server-Wide Worker Threads Statistics Metrics
Metric | Description |
---|---|
Max number of worker processes ever in use |
The maximum number of worker processes that have ever been in use. |
Max number of worker processes ever in use |
The maximum number of worker processes that have ever been in use. |
Max parallel degree |
The maximum degree of parallelism that can be used (the current Run Value for max parallel degree) in configuration parameter. |
Max scan parallel degree |
The maximum degree of parallelism that can be for a scan (the current Run Value for max scan parallel degree) in configuration parameter). |
For Release 6 Number of attempted parallel queries For Release 7 Attempted parallel queries (SysWorkerThread) rate (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of attempted parallel queries since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the parallel queries were attempted since last collection, that is, the number of attempted parallel queries since last collection divided by the elapsed time between two collections. |
For Release 6 Number of altered plans For Release 7 Altered plans (SysWorkerThread) rate (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of altered plans since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which altered plans were made since last collection, that is, the number of altered plans since last collection divided by the elapsed time between two collections. |
Number of active worker processes |
Number of worker processes active. The upload frequency is after every sample. The operator is >. Alert text is - The total number active worker processes are %ThreadsActive%. It has crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Total memory configured for worker processes (Bytes) |
The amount of memory configured for use by worker processes. |
Max configured worker processes |
Configured maximum number of worker processes. |
Total memory in use by worker processes (Bytes) |
The amount of memory currently in use by worker processes. |
Max memory ever used by worker processes (Bytes) |
The maximum amount of memory ever used by worker processes. |