This view shows the effectiveness of the data caches of Adaptive Server since the start of the session. It shows the:
Percentage of requests for page reads that were satisfied from cache for the session
Number of logical reads, physical reads, and page writes for the session
Rate of logical reads, physical reads, and page writes for the session
SMC_SIZET session_page_cache_stats_count = 7;
SMC_DATAITEM_STRUCT session_page_cache_stats_view[] = {
{ SMC_NAME_PAGE_HIT_PCT, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_PAGE_LOGICAL_READ, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_PAGE_LOGICAL_READ, SMC_STAT_RATE_SESSION },
{ SMC_NAME_PAGE_PHYSICAL_READ, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_PAGE_PHYSICAL_READ, SMC_STAT_RATE_SESSION },
{ SMC_NAME_PAGE_WRITE, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_PAGE_WRITE, SMC_STAT_RATE_SESSION }
};
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
