The metrics in this category provide statistics relating to Adaptive Server data caches.
Collection frequency - Every 60 minutes
Table 3-11 Data Caches Statistics Metrics
| Metric | Description and User Action |
|---|---|
|
Number of Buffer Pools Within the Cache |
The number of buffer pools within the cache. |
|
Number of partitions currently configured for the cache |
Number of partitions currently configured for the cache. |
|
For Release 6 Cache searches directed to the cache For Release 7 Cache searches directed to the cache (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of buffers that were fetched and replaced in the most recently used portion of the pool, 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 fetched and replaced in the most recently used portion of the pool, that is, the number of buffers that were fetched and replaced since last collection divided by the elapsed time between two collections. |
|
Data Cache Hit Ratio (%) |
Percentage of Data Cache Hit Ratio. |
|
For Release 6 Number of buffers retrieved from the cache For Release 7 Buffers retrieval rate from the data cache (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of buffers retrieved 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 retrieved from the cache since last collection, that is, the number of buffers retrieved from the cache since last collection divided by the elapsed time between two collections. |
|
Miss Ratio (%) |
Percentage Cache Miss Ratio. |
|
For Release 6 Number of buffers read into the cache from disk For Release 7 Buffers read rate from the disk to data 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 into the cache from 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 into the cache from disk since last collection, that is, the number of buffers read into the cache from disk since last collection divided by the elapsed time between two collections. |
|
For Release 6 Number of buffers written from the cache to disk For Release 7 Buffers write rate from the data cache 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 from the cache to 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 buffers were written from the cache to disk, that is, the number of buffers written from the cache to disk divided by the elapsed time between two collections. |
|
Is relaxed replacement policy |
Whether the cache is using relaxed cache replacement strategy. |
|
For Release 6 Number of dirty buffer retrievals For Release 7 Dirty buffer retrievals rate from data cache (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of dirty buffer retrievals since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which dirty buffers were retrieved since last collection, that is, the number of dirty buffer retrievals since last collection divided by the elapsed time between two collections. |
|
Cache ID |
Cache identifier. |
|
Cache Name |
Name of the cache. |