This view shows the effectiveness of the data caches of Adaptive Server for the most recent sample interval. It shows the:
Percentage of requests for page reads that were satisfied from cache for the most recent sample interval
Number of logical reads, physical reads, and page writes for the most recent sample interval
Rate of logical reads, physical reads, and page writes for the most recent sample interval
SMC_SIZET sample_page_cache_stats_count = 7;
SMC_DATAITEM_STRUCT sample_page_cache_stats_view[] = {
{ SMC_NAME_PAGE_HIT_PCT, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_LOGICAL_READ, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_LOGICAL_READ, SMC_STAT_RATE_SAMPLE },
{ SMC_NAME_PAGE_PHYSICAL_READ, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_PHYSICAL_READ, SMC_STAT_RATE_SAMPLE },
{ SMC_NAME_PAGE_WRITE, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_WRITE, SMC_STAT_RATE_SAMPLE }
};
