Interpret the Data Cache window for Adaptive Server.
The Data Cache window displays information about Adaptive Server data caches. In Adaptive Server cluster configurations, the Global Datacaches window provides information about the global Adaptive Server 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.
Right-click on a selected cache to use Resize to modify the size of the data cache, or Add Buffer Pool to change the configuration of your data cache buffer pool.
| Pool Information | Shows information about the pools of different sizes that are used to 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 on 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. |