Data Cache Statistics and Details

The Data Cache window displays information about SAP ASE data caches.

In cluster configurations, the Global Datacaches window provides information about the global data caches and the Local Datacaches screen provides information about local data caches grouped by cluster instances.

The Data Caches table shows the size and level of activity in each data cache, including hit rate (the percentage of database requests that can be answered from the cache), volatility, number of partitions in this cache, relaxed replacement, and physical reads and writes. Select a cache in the table to populate the tabs at the bottom of the screen with details about that cache. To view the Data Caches table, from the Perspective Resources view, select the server to monitor, click the drop-down arrow, and select Monitor.

Right-click a selected cache and select Resize to modify the size of the data cache, or Add Buffer Pool to change the configuration of your data cache buffer pool.

Tabs on the Data Cache Window
Pool Information Shows information about the pools of different sizes that optimize I/O in the selected cache. Details include size, usage, reread ratio, physical and dirty reads, pages touched, buffers to MRU (most recently used), and buffers to LRU (least recently used). The Buffers to MRU and Buffers to LRU columns show buffers added to the ends of the buffer list. The oldest buffers (the least recently used) are flushed first.
Cached Objects Lists the tables in the selected data cache and their size, in kilobytes. Click the Cached Size column heading to sort the table by size.
Distribution Shows information about the distribution metrics for each instance of a cluster, including hit rate, volatility, cache partitions, relaxed replacement, and physical reads and writes.
Related tasks
Monitoring SAP ASE Data Caches
Monitoring the SAP ASE Procedure Cache
Monitoring the SAP ASE Statement Cache
Monitoring SAP ASE In-memory Storage
Related reference
Procedure Cache Statistics and Details
Statement Cache Statistics and Details
In-memory Storage Statistics and Details