Device IO

Device I/O activity

Columns

Name Description
Inst ID Instance ID; 0 = non-CE
Name Logical name for the device
Physical IOs / Sec Number of reads per second, in interval + Number of writes per second, in interval + Number of asynchronous prefetch (APF) reads per second, in interval
IO Time Duration time per I/O operation in interval
Avg IO Time Average duration time per I/O operation in interval
% Total IO % of total number of I/O operations per second, in interval, over all devices
Avg IOs / Sec Average number of I/O operations per second, since collection started
Semaphore Waits Total number of waits for sync on I/O operation to mirrored device, if applicable, since collection started
Reads / Sec Number of reads per second, in interval
Writes / Sec Number of writes per second, in interval
APF Reads / Sec Number of asynchronous prefetch (APF) reads per second, in interval
Ovr Reads Total number of reads, since collection started
Ovr Writes Total number of writes, since collection started
Ovr APF Reads Total number of asynchronous prefetch (APF) reads, since collection started
Device Type Type of device (Default Disk, Physical Disk, Dump Device)
Physical Name Full file path for the device

Entity Requirements

Attributes: MDA
Minimum database version: 12.5.0.3

Sample