Sybase 12.5.1, User Manual

Page: 193 / 210

APPENDIX D Examples of Recording Session Views
User’s Guide
179
Device I/O performance summary
This view represents reads and writes to database devices by Adaptive Server,
accumulated from the start of the recording session. It shows the overall rate of
reads and writes to database devices since the start of the session, as well as the
most active database device for that time period and the rate of reads and writes
to the most active device.
hs_create_view device_perf_sum,
"Device I/O", "Rate for Session",
"Most Active Device Name", "Value for Session",
"Most Active Device I/O", "Rate for Session"
Engine activity
This view shows the level of activity for each active Adaptive Server engine
during the most recent sample interval. For each engine, the percentage of the
sample interval, when that engine used the CPU, is presented.
Also shown are the number of logical page reads, physical page reads, and page
writes that were generated by that engine during the sample interval.
hs_create_view engine_activity,
"Engine Number", "Value for Sample",
"CPU Busy Percent", "Value for Sample",
"Logical Page Reads", "Value for Sample",
"Physical Page Reads", "Value for Sample",
"Page Writes", "Value for Sample"
Lock performance summary
This view represents the total number of locks of each type requested and
granted during the most recent sample interval.
hs_create_view lock_perf_sum,
"Lock Type", "Value for Sample",
"Lock Results Summarized", "Value for Sample",
"Lock Count", "Value for Sample"