Stores statistics for all pools allocated for all data caches.
Enable the enable monitoring configuration parameter for this monitoring table to collect data.
The columns for monCachePool are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
CacheID |
int |
Unique identifier for the cache |
|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
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 |
LogicalReads |
int |
Counter |
Number of buffers read from the pool |
PhysicalWrites |
int |
Counter |
Number of write operations performed for data in this pool (one write operation may include multiple pages) |
APFReads |
int |
Counter |
Number of asynchronous prefetch (APF) read operations that loaded pages into this pool |
APFPercentage |
int |
The configured asynchronous prefetch limit for this pool |
|
WashSize |
int |
The wash size, in kilobytes, for a memory pool |
