Action

If you are not using Adaptive Server mirroring, set disable disk mirroring to 1. If you are using mirroring, high values for WaitTime may indicate a loss of performance from device contention. Query monIOQueue and monDeviceIO to determine if there is a slow or overloaded disk device. Evaluate the results to determine if you can shift some of the load to other devices.