This view summarizes the page I/Os for each Adaptive Server process for the most recent sample. For each process in Adaptive Server that generated page I/Os during the interval, it shows the login name, Process ID, and Kernel Process ID.
This view also shows, for each process:
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 writes for the most recent sample interval
SMC_SIZET process_page_io_count = 8;
SMC_DATAITEM_STRUCT process_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_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 }
};
