I/O Bottleneck Detected

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 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