The metrics in this category provide state and statistical information pertaining to databases that are currently in use.
Collection frequency - Every 1 hour
Table 3-33 Open Databases Statistics Metrics
Metric | Description |
---|---|
For Release 6 Number of append log semaphore requests For Release 7 Append log semaphore request rate (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of semaphore requests when attempting to append to the database transaction log. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the semaphore requests were made since last collection, that is, the number of semaphore requests made since last collection (when attempting to append to the database transaction log) divided by the elapsed time between two collections. |
For Release 6 Number of append log semaphore waits For Release 7 Append log semaphore Waits rate (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of times a task had to wait for the append log semaphore to be granted. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which a task had to wait for the append log semaphore to be granted since last collection, that is, the number of times a task had to wait for the append log semaphore to be granted divided by the elapsed time between two collections. |
For Release 7 Append log semaphore Waits (%) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Percentage of tasks that had to wait for the append log semaphore to be granted since last collection. |
Is backup in progress |
Whether a backup is currently in progress for the database. |
Last backup start time |
Date that the last backup started for the database. |
Is last backup failed |
Whether the last backup of the database failed. |
Is transaction log full |
Whether the database transaction log is full. |
DBID |
Database identifier. |
DB Name |
The name of the database. |