This view shows the effectiveness of the procedure cache of 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
Number of logical reads and physical reads of stored procedures during the most recent sample interval
Rate of logical and physical reads of stored procedures for the most recent sample interval
SMC_SIZET sample_procedure_cache_stats_count = 5;
SMC_DATAITEM_STRUCT sample_procedure_cache_stats_view[] = {
{ SMC_NAME_STP_HIT_PCT, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_STP_LOGICAL_READ, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_STP_LOGICAL_READ, SMC_STAT_RATE_SAMPLE },
{ SMC_NAME_STP_PHYSICAL_READ, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_STP_PHYSICAL_READ, SMC_STAT_RATE_SAMPLE }
};
