monDataCache

Stores statistics relating to Adaptive Server data caches.

Enable the enable monitoring configuration parameter for this monitoring table to collect data.

The columns for monDataCache 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.
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
Status	varchar(30)	null	Status of cache. One of: Active Pending/Active Pending/Delete Update Cache Cache Create Cache Delete (Cluster Edition only) Cache Skip
Type	varchar(30)	null	Type of cache. One of: Default Mixed Mixed, HK Ignore Log Only In-Memory Storage
CacheSize	int		Total size of cache, in kilobytes
ReplacementStrategy	varchar(30)	null	Cache replacement strategy
APFReads	int	Counter	Number of asynchronous prefetch (APF) reads for this data cache
Overhead	int		Cache overhead