Stores statistics relating to Adaptive Server data caches.
Enable the enable monitoring configuration
parameter for this monitoring table to collect data.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
CacheID |
int |
Unique identifier for the cache |
|
RelaxedReplacement |
int |
Specifies whether the cache is using relaxed cache replacement strategy |
|
BufferPools |
int |
Number of buffer pools within the cache |
|
CacheSearches |
int |
Counter, reset |
Cache searches directed to the cache |
PhysicalReads |
int |
Counter, reset |
Number of buffers read into the cache from disk |
LogicalReads |
int |
Counter, reset |
Number of buffers retrieved from the cache |
PhysicalWrites |
int |
Counter, reset |
Number of buffers written from the cache to disk |
Stalls |
int |
Counter, reset |
Number of times I/O operations were delayed because no clean buffers were available in the wash area |
CachePartitions |
smallint |
Number of partitions currently configured for the cache |
|
CacheName |
varchar(30) |
Null |
Name of cache |
