This view shows objects in the Adaptive Server databases and the page I/Os associated with them. It shows the Adaptive Server database name and ID and the object names and IDs within each database. This view shows for each object the associated logical page reads, physical page reads, and page writes for both the most recent sample interval and for the recording session.
hs_create_view object_page_io, "Database ID", "Value for Sample", "Database Name", "Value for Sample", "Object ID", "Value for Sample", "Object Name", "Value for Sample", "Logical Page Reads", "Value for Sample", "Physical Page Reads", "Value for Sample", "Page Writes", "Value for Sample", "Logical Page Reads", "Value for Session", "Physical Page Reads", "Value for Session", "Page Writes", "Value for Session"
