This view shows page I/Os that occurred while running stored procedures during the most recent sample interval. For each stored procedure that generated page I/Os during the sample interval, it shows the stored procedure name and ID, together with the name and ID of the database that contains the procedure. If page I/Os were produced when no stored procedure was active, those I/Os are associated with procedure ID and database ID values of zero.
This view also shows, on a per stored procedure level:
Total page I/Os
Percentage of page I/O requests that could be satisfied by Adaptive Server data caches
Number of logical reads, physical reads, and page writes generated while executing the stored procedures during the most recent sample interval.
SMC_SIZET procedure_page_cache_io_count = 9;
SMC_DATAITEM_STRUCT procedure_page_cache_io_view[] = {
{ SMC_NAME_ACT_STP_DB_NAME, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_ACT_STP_DB_ID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_ACT_STP_NAME, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_ACT_STP_ID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_IO, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_HIT_PCT, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_LOGICAL_READ, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_PHYSICAL_READ, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_WRITE, SMC_STAT_VALUE_SAMPLE }
};
