The metrics in this category provide statistics regarding Adaptive Server engines.
Collection Frequency - Every 30 minutes.
Table 3-1 Adaptive Server Engines Statistics Metrics
| Metric | Description and User Action |
|---|---|
|
Number of CPU that the engine is affinited to |
The number of CPUs that the engine affinited to. |
|
For Release 6 Number of handled connections For Release 7 Engine's connections handle rate (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of connections handled 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 connections were handled since last collection, that is, the number of connections handled since last collection divided by the elapsed time between two collections. |
|
For Release 6 Number of context switches For Release 7 Engine's context switch rate (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of context switches handled since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate of context switches handled since last collection, that is, the number of context switches handled since last collection divided by the elapsed time between two collections. |
|
For Release 6 Total Time Engine Running (seconds) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Total time (in seconds) the engine has been running. |
|
Current KPID |
Kernel process identifier for the currently executing process. |
|
For Release 6 \Total time engine has been in idle spin mode (seconds) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Time (in seconds) the engine has been in idle spin mode. |
|
OS Process ID |
OS Process ID. |
|
Number of affinited processes to engine |
Number of processes that have been affinitied to this engine. |
|
Engine came online (Date) |
Date that the engine came online. |
|
Engine Status |
Status of the engine (online, offline, and so on). |
|
Engine went offline (Date) |
Date that the engine went offline. |
|
For Release 6 Total time engine executing system database services (seconds) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Time (in seconds) the engine has been executing system database services. |
|
Engine CPU (for System DB Services) Utilization % |
Engine CPU Utilization (System DB Services). |
|
For Release 6 Total time engine executing user commands (seconds) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Time (in seconds) the engine has been executing user commands. |
|
Engine CPU (for User Commands) Utilization % |
Engine CPU Utilization (for User Commands) |
|
Engine Number |
Number of the Sybase ASE engine |
|
Number of processes affinited to engine |
Number of processes with affinity to the engine |
|
Previous KPID |
Kernel process identifier for the previous executing process. |