Returns statistical information relating to activity on database devices.
Enable the enable monitoring configuration parameter for this monitoring table to collect data.
The columns for monDeviceIO are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
Reads |
int |
Counter, reset |
Number of reads from the device |
APFReads |
int |
Counter, reset |
Number of asynchronous prefetch (APF) reads from the device |
Writes |
int |
Counter, reset |
Number of writes to the device |
DevSemaphoreRequests |
int |
Counter, reset |
Number of I/O requests to a mirrored device (if mirrored) |
DevSemaphoreWaits |
int |
Counter, reset |
Number of tasks forced to wait for synchronization of an I/O request to a mirrored device (if mirrored) |
IOTime |
int |
Counter |
Total amount of time (in milliseconds) spent waiting for I/O requests to be satisfied |
LogicalName |
varchar(30) |
Null |
Logical name of the device |
PhysicalName |
varchar(128) |
Null |
Full hierarchic file name of the device |
