Sybase 12.5.1, User Manual

Page: 200 / 210

Process locks
186
Historical Server
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"
Process locks
This view shows the count of lock requests for every process in the Adaptive
Server that generated lock requests during the most recent sample interval.
hs_create_view process_lock,
"Login Name", "Value for Sample",
"Process ID", "Value for Sample",
"Kernel Process ID", "Value for Sample",
"Lock Count", "Value for Sample"
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",