Provides device I/O statistics broken down into data and log I/O for normal and temporary databases on each device. monIOQueue requires the enable monitoring configuration parameter to be enabled.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
IOs |
int |
counter |
Total number of I/O operations |
IOTime |
int |
counter |
Amount of time (in milliseconds) spent waiting for I/O requests to be satisfied |
LogicalName |
varchar(30) |
null |
Logical name of the device |
IOType |
varchar(12) |
null |
Category for grouping I/O (‘user data’, ‘User log’, ‘Tempdb Data’, or ‘Tempdb log’) |
