I/O Bottleneck
An entry of "I/O stalls requests taking longer than 15 seconds to complete" has been found in the SQL Server error log.
| AVG I/O Stall (ms) | Meaning |
|---|---|
| <10ms | Very good |
| 10 - 20ms | Acceptable |
| 20 - 50ms | Slow, requires attention |
| >50ms | Serious I/O bottleneck |
Suggested Action
Identify and resolve the cause of the I/O bottleneck.
Further Reading
How to examine IO subsystem latencies from within SQL Server | SQLSkills
Investigating I/O bottlenecks | MSSQLTips.com
Troubleshooting Performance Problems in SQL Server 2005 | Microsoft Technet
Troublehooting SQL Server I/O requests taking longer than 15 seconds | Microsoft Developer
How to choose antivirus software to run on computers that are running SQL Server | Microsoft Support
Recommended antivirus exclusions for Hyper-V hosts | Microsoft Support