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"
