Sybase 12.5.1, Руководство пользователя

Страница: 192 / 210

Device I/O for recording session
178
Historical Server
Device I/O for recording session
This view represents the I/O activity that occurred on Adaptive Server database
devices since the start of the recording session. It identifies each device by
name. Device I/O levels are presented in two ways: as counts of total device
I/Os, reads and writes since the start of the session, and also as overall rates of
total I/Os, reads and writes per second since the session began.
hs_create_view session_device_io,
"Device Name", "Value for Sample",
"Device Reads", "Value for Session",
"Device Writes", "Value for Session",
"Device I/O", "Value for Session",
"Device Reads", "Rate for Session",
"Device Writes", "Rate for Session",
"Device I/O", "Rate for Session"
Device I/O for sample interval
This view represents the I/O activity that occurred on the Adaptive Server
database devices during the most recent sample interval. It identifies each
device by name. Device I/O levels are presented in two ways: as counts of total
device I/Os, reads and writes during the most recent sample interval, and also
as rates of total I/Os, reads and writes per second during the sample interval.
hs_create_view sample_device_io,
"Device Name", "Value for Sample",
"Device I/O", "Value for Sample",
"Device Reads", "Value for Sample",
"Device Writes", "Value for Sample",
"Device I/O", "Rate for Sample",
"Device Reads", "Rate for Sample",
"Device Writes", "Rate for Sample"