This view shows the page I/Os associated with stored procedure executions by Adaptive Server processes. It shows the login name, Process ID, and Kernel Process ID for each process that generated page I/Os during the sample interval.
For each process and stored procedure that generated page I/Os, it shows the name and ID of the database that contains the stored procedure, and the name and ID of the procedure.
For the most recent sample interval, the view shows the:
Total page I/Os
Percentage of page I/O requests that could be satisfied from data caches
Number of logical reads, physical reads, and page writes
SMC_SIZET process_procedure_page_io_count = 12;
SMC_DATAITEM_STRUCT process_procedure_page_io_view[] = {
{ SMC_NAME_LOGIN_NAME, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_SPID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_KPID, SMC_STAT_VALUE_SAMPLE },
{ 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 }
};
