SQL Server has encountered % occurrence(s) of IO requests taking longer than 15 seconds to complete on file
By now you should have applied the Service Pack 4 on your SQL Server 2000 instances and you might come across the message within the SQL error log "SQL Server has encountered 5877 occurrence(s) of IO requests taking longer than 15 seconds to complete on file".
Though this is classed as an informational message you should be concerned to take care to avoid any further performance loss. This informational message indicates that the current load may be experiencing one of the following conditions:
| • |
The workload is exceeding the I/O path capabilities. |
| • |
The workload is exceeding the current system capabilities. |
| • |
The I/O path has malfunctioning software; perhaps a firmware or a driver issue. |
| • |
The I/O path has malfunctioning hardware components. |
To checkup and resolve refer to FAQ post.
**__________________________________**
SQL Server MVP, Sr. DBA & industry expert.
-
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.