Provides statistics for all pools allocated for all caches. Requires the enable monitoring configuration parameter to be enabled.
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 that have been allocated for the pool |
|
PhysicalReads |
int |
counter |
Number of buffers that have been read from disk into the pool |
Stalls |
int |
counter |
Number of dirty buffer retrievals |
PagesTouched |
int |
counter |
Number of bytes that are currently being used within the pool |
PagesRead |
int |
counter |
Number of pages read into the pool |
BuffersToMRU |
int |
counter |
The number of buffers that were fetched and replaced in the most recently used portion of the pool |
BuffersToLRU |
int |
counter |
The number of buffers that were fetched and replaced in the least recently used portion of the pool |
CacheName |
varchar(30) |
null |
Name of the cache |
