Returns statistics relating to Adaptive Server data caches. Requires the enable monitoring configuration parameter to be enabled.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
CacheID |
int |
Unique identifier for the cache |
|
RelaxedReplacement |
int |
Whether the cache is using relaxed cache replacement strategy |
|
BufferPools |
int |
The number of buffer pools within the cache |
|
CacheSearches |
int |
counter |
Cache searches directed to the cache |
PhysicalReads |
int |
counter |
Number of buffers read into the cache from disk |
PhysicalWrites |
int |
counter |
Number of buffers written from the cache to disk |
LogicalReads |
int |
counter |
Number of buffers retrieved from the cache |
Stalls |
int |
counter |
Number of “dirty” buffer retrievals |
CachePartitions |
smallint |
Number of partitions currently configured for the cache |
|
CacheName |
varchar(30) |
null |
Name of cache |
