This view represents the overall effectiveness of Adaptive Server caches during the most recent sample interval. It shows the percentage of data page reads that are satisfied from the Adaptive Server data caches, as well as the percentage of requests for procedure executions that are satisfied from the Adaptive Server procedure cache.
hs_create_view cache_perf_sum, "Page Hit Percent", "Value for Sample", "Procedure Hit Percent", "Value for Sample"
