The metrics in this category provide detailed statistics about process activity.
Collection frequency - Every 30 minutes
Table 3-40 Process Activity Statistics Metrics
| Metric | Description |
|---|---|
|
For Release 6 Number of transactions committed by the process For Release 7 Transaction commit (process) rate (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of transactions committed by the process 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 transactions were committed by the process since last collection, that is, the number of transactions committed by the process since last collection divided by the elapsed time between two collections. |
|
CPU Usage by process (ms) |
CPU time (in milliseconds) used by the process. |
|
For Release 6 Number of pages where data was retrieved using an index For Release 7 Page retrieval rate (per sec) for data using an index |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of pages where data was retrieved using an index 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 data was retrieved using an index since last collection, that is, the number of pages where data was retrieved using an index since last collection divided by the elapsed time between two collections. |
|
Number of locks currently held by the process |
Number of locks currently held by the process. |
|
For Release 6 Number of buffers read from cache For Release 7 Buffers read (process) rate from cache (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of buffers read from the cache 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 buffers were read from the cache since last collection, that is, the number of buffers read from the cache since last collection divided by the elapsed time between two collections. |
|
Allocated memory (bytes) |
Amount of memory (in bytes) allocated to the process. |
|
For Release 6 Number of pages read For Release 7 Page read (process) rate (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of pages read 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 pages were read since last collection, that is, the number of pages read since last collection divided by the elapsed time between two collections. |
|
For Release 6 Number of pages written For Release 7 Page write (process) rate (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of pages written 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 pages were written since last collection, that is, the number of pages written since last collection divided by the elapsed time between two collections. |
|
For Release 6 Number of buffers read from disk For Release 7 Buffer read (process) rate from disk (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of buffers read from the disk 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 buffers were read from the disk since last collection, that is, the number of buffers read from the disk since last collection divided by the elapsed time between two collections. |
|
For Release 6 Number of buffers written to disk For Release 7 Buffer write (process) rate to disk (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of buffers written to the disk 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 buffers were written to the disk since last collection, that is, the number of buffers written to the disk since last collection divided by the elapsed time between two collections. |
|
For Release 6 Number of transactions rolled back by the process For Release 7 Transactions roll-back (process) rate (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of transactions rolled back by the process 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 transactions were rolled back by the process since last collection, that is, the number of transactions rolled back by the process since last collection divided by the elapsed time between two collections. |
|
Number of pages where data was retrieved without an index |
Number of pages where data was retrieved without an index. |
|
For Release 6 Number of temporary table objects accessed For Release 7 Temporary tables (process) creation/access rate (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of temporary table objects accessed 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 temporary table objects were accessed since last collection, that is, the number of temporary table objects accessed since last collection divided by the elapsed time between two collections. |
|
For Release 6 Number of transactions started by the process For Release 7 Transactions start (process) rate (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of transactions started by the process 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 transactions were started by the process since last collection, that is, the number of transactions started by the process since last collection divided by the elapsed time between two collections. |
|
For Release 6 Number of bytes written to the user log cache for the process For Release 7 Write rate (bytes/sec) to the ULC for the process |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of bytes written to the user log cache for the process 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 bytes were written to the user log cache since last collection, that is, the number of bytes written to the user log cache for the process since last collection divided by the elapsed time between two collections. |
|
Current usage (bytes) of the User log cache by the process |
The current usage (bytes) of the User log cache by the process. |
|
For Release 6 Total number of times the user log cache was flushed For Release 7 User Log Cache flush rate (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Total number of times the user log cache was flushed 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 user log cache was flushed since last collection, that is, number of times the user log cache was flushed since last collection divided by the elapsed time between two collections. |
|
For Release 6 Number of times the user log cache was flushed For Release 7 User Log Cache flush rate [due to ULC full] (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of times the user log cache was flushed because it was full 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 user log cache was flushed since last collection, that is, the number of times the user log cache was flushed since last collection divided by the elapsed time between two collections. |
|
Maximum ever usage (bytes) of the user log cache |
The maximum ever usage (in bytes) of the user log cache by the process. |
|
Waited time by process (ms) |
Time (in milliseconds) the process has spent waiting. |
|
KPID |
Kernel process identifier. |
|
Login Name |
Login user name. |
|
Page retrieval rate (per sec) for data without an index |
Page retrieval rate (per sec) for data without an index |
|
SPID |
Session process identifier. |
|
The current usage (bytes) of the User log cache by the process |
The current usage (bytes) of the User log cache by the process |
|
The maximum ever usage (bytes) of the user log cache |
The maximum ever usage (bytes) of the user log cache |