Provides device I/O statistics displayed as data and log I/O for normal and temporary databases on each device.
Enable the enable monitoring configuration parameter for this monitoring table to collect data.
The columns for monIOQueue are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
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. One of UserData, UserLog, TempdbData, TempdbLog, or System. |
