This view represents the effectiveness of the procedure cache of the Adaptive Server for the most recent sample interval. It shows the percentage of requests for stored procedure executions that were satisfied by the procedure cache for the most recent sample interval.
The view also shows the number of logical reads and physical reads of stored procedures during the most recent sample interval, and the rate of logical and physical reads of stored procedures for the most recent sample interval.
hs_create_view sample_procedure_cache_stats, "Procedure Hit Percent", "Value for Sample", "Procedure Logical Reads", "Value for Sample", "Procedure Logical Reads", "Rate for Sample", "Procedure Physical Reads", "Value for Sample", "Procedure Physical Reads", "Rate for Sample"
