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"
