This view represents the effectiveness of the procedure cache of the Adaptive Server since the start of the recording session. It shows the percentage of requests for stored procedure executions that were satisfied by the procedure cache.
The view also shows the number of logical reads and physical reads of stored procedures since the start of the session, and the overall rate of logical and physical reads of stored procedures since the start of the session.
hs_create_view session_procedure_cache_stats, "Procedure Hit Percent", "Value for Session", "Procedure Logical Reads", "Value for Session", "Procedure Logical Reads", "Rate for Session", "Procedure Physical Reads", "Value forSession", "Procedure Physical Reads", "Rate for Session"
