Sybase 12.5.1, User Manual

Page: 191 / 210

APPENDIX D Examples of Recording Session Views
User’s Guide
177
Data cache statistics for recording session
This view represents the overall effectiveness of the combined data caches of
the Adaptive Server since the start of the recording session. It shows the
percentage of requests for page reads that were satisfied from cache for the
recording session.
The view also shows the number and rate of logical page reads, physical page
reads, and page writes for the recording session.
hs_create_view session_page_cache_stats,
"Page Hit Percent", "Value for Session",
"Logical Page Reads", "Value for Session",
"Logical Page Reads", "Rate for Session",
"Physical Page Reads", "Value for Session",
"Physical Page Reads", "Rate for Session",
"Page Writes", "Value for Session",
"Page Writes", "Rate for Session"
Data cache statistics for sample interval
This view represents the overall effectiveness of the combined data caches of
the 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.
The view also shows the number and rate of logical page reads, physical page
reads, and page writes for the most recent sample interval.
hs_create_view sample_page_cache_stats,
"Page Hit Percent", "Value for Sample",
"Logical Page Reads", "Value for Sample",
"Logical Page Reads", "Rate for Sample",
"Physical Page Reads", "Value for Sample",
"Physical Page Reads", "Rate for Sample",
"Page Writes", "Value for Sample",
"Page Writes", "Rate for Sample"