Sybase 12.5.1, User Manual

Page: 198 / 210

Process database object page I/O
184
Historical Server
"Login Name", "Value for Sample",
"Process ID", "Value for Sample",
"Kernel Process ID", "Value for Sample",
"Connect Time", "Value for Session",
"Page I/O", "Value for Session",
"CPU Time", "Value for Session",
"Current Process State", "Value for Sample"
Process database object page I/O
This view represents the page I/Os by database object for each Adaptive Server
process. It shows the login name, Process ID, and Kernel Process ID for each
process that had page I/Os during the most recent sample interval.
For each such process and for each database object it accessed, the view also
shows the object name, object ID, and the object’s database name and ID, plus
the page I/Os associated the object.
The view also shows the total page I/Os, the percentage of page I/O requests
that could be satisfied by the Adaptive Server cache, and the number of logical
page reads, physical page reads, and page writes for the most recent sample
interval.
hs_create_view process_object_page_io,
"Login Name", "Value for Sample",
"Process ID", "Value for Sample",
"Kernel Process ID", "Value for Sample",
"Database Name", "Value for Sample",
"Database ID", "Value for Sample",
"Object Name", "Value for Sample",
"Object ID", "Value for Sample",
"Object Type", "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"