Process page I/O

This view represents the page I/Os summarized on a per Adaptive Server process level for the most recent sample. It shows the login name, Process ID, and Kernel Process ID for each process in the Adaptive Server that generated page I/Os during the interval.

This view also shows, on a per process level, the total page I/Os, the percentage of page I/O requests that could be satisfied by the Adaptive Server data caches, and the number of logical page reads, physical page reads, and writes for the most recent sample interval.

hs_create_view process_page_io,
"Login Name", "Value for Sample",
"Process ID", "Value for Sample",
"Kernel Process ID", "Value for Sample",
"Page I/O", "Value for Sample",
"Page Hit Percent", "Value for Sample",
"Logical Page Reads", "Value for Sample",
"Physical Page Reads", "Value for Sample",
"Page Writes", "Value for Sample"