This view represents the page I/Os for each Adaptive Server process in detail. The login name, Process ID, Kernel Process ID, current process state and current engine are shown for each Adaptive Server process as of the end of the most recent sample interval. The view shows the percentage of page I/O requests that could be satisfied by the Adaptive Server data caches, both for the sample interval and since the start of the session.
This view also presents the number of logical page reads, physical page reads, and page writes accumulated since the start of the recording session.
hs_create_view process_detail_io, "Login Name", "Value for Sample", "Process ID", "Value for Sample", "Kernel Process ID", "Value for Sample", "Current Process State", "Value for Sample", "Current Engine", "Value for Sample", "Connect Time", "Value for Session", "CPU Time", "Value for Session", "Page Hit Percent", "Value for Sample", "Page Hit Percent", "Value for Session", "Logical Page Reads", "Value for Session", "Physical Page Reads", "Value for Session", "Page Writes", "Value for Session"
