This view shows the page I/Os for each Adaptive Server process in detail. It shows the following as of the end of the most recent sample interval:
Login name
Process ID
Kernel Process ID
Process state and current engine are shown for each Adaptive Server process
The view shows the percentage of page I/O requests that could be satisfied by Adaptive Server data caches, both for the sample interval and since the start of the session. It also shows the number of logical reads, physical reads, and page writes since the start of the session.
SMC_SIZET process_detail_io_count = 12;
SMC_DATAITEM_STRUCT process_detail_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_CUR_PROC_STATE, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_CUR_ENGINE, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_CONNECT_TIME, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_CPU_TIME, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_PAGE_HIT_PCT, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_HIT_PCT, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_PAGE_LOGICAL_READ, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_PAGE_PHYSICAL_READ, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_PAGE_WRITE, SMC_STAT_VALUE_SESSION }
};
