Stores statistics for all pools allocated for all 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 |
|
IOBufferSize |
int |
Size (in bytes) of the I/O buffer for the pool |
|
AllocatedKB |
int |
Number of bytes allocated for the pool |
|
PhysicalReads |
int |
Counter |
Number of buffers read from disk into the pool |
Stalls |
int |
Counter |
Number of times I/O operations were delayed because no clean buffers were available in the wash area for this data cache |
PagesTouched |
int |
Counter |
Number of pages that are currently being used within the pool |
PagesRead |
int |
Counter |
Number of pages read into the pool |
BuffersToMRU |
int |
Counter |
Number of buffers fetched and replaced in the most recently used portion of the pool |
BuffersToLRU |
int |
Counter |
Number of buffers fetched and replaced in the least recently used portion of the pool: fetch and discard. |
CacheName |
varchar(30) |
Null |
Name of the cache |
