Process stored procedure page I/O

This view represents 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, as well as the name and ID of the procedure itself.

The view also shows the total page I/Os, the percentage of page I/O requests that could be satisfied from data caches, and the number of logical page reads, physical page reads, and page writes for the most recent sample interval.

hs_create_view process_procedure_page_io,
"Login Name", "Value for Sample",
"Process ID", "Value for Sample",
"Kernel Process ID", "Value for Sample",
"Procedure Database Name", "Value for Sample",
"Procedure Database ID", "Value for Sample",
"Procedure Name", "Value for Sample",
"Procedure 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"