| Event Information | According to Microsoft:
Cause:
This message indicates that SQL Server has issued a read or write request from disk, and that the request has taken longer than 15 seconds to return. This error is reported by SQL Server and indicates a problem with the IO subsystem.Possible Causes
This problem can be caused system performance issues, hardware errors, firmware errors, device driver problems, or filter driver intervention in the IO process.
Resolution:
Troubleshoot this error by examining the system event log for hardware-related error messages. Also, examine hardware-specific logs if they are available.
Use Performance Monitor to examine the following counters:
*Average Disk Sec/Transfer
*Average Disk Queue Length
*Current Disk Queue Length
For example, the Average Disk Sec/Transfer time on a computer that is running SQL Server is typically less than 15 milliseconds. If the Average Disk Sec/Transfer value increases, this indicates that the I/O subsystem is not optimally keeping up with the I/O demand.
Note:Disk access can be slowed by an antivirus program. To increase access speed, exclude the SQL Server data files that are specified in the error message from active virus scans. |
