Processes Activity Statistics

The metrics in this category provide detailed statistics about process activity. Collection frequency - Every 30 mins

Elapsed time since connection established (seconds)

Number of seconds since this connection was established.

Process waiting time (seconds) Amount of time in seconds that the process has been waiting, if the process is currently in a wait state.

Wait Event ID Unique identifier for the event that the process is waiting for, if the process is currently in a wait state.

Table 3–19 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 retrival 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 nmber 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.

Table 3–18 (Cont.) Process Statistics Metrics

Processes Activity Statistics

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. Table 3–19 (Cont.) Process Activity Statistics Metrics

Process Tracking Details