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"