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.
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. One of UserData, UserLog, TempdbData, TempdbLog. |
