Detecting and Resolving Stalled and Stuck I/O…

Detecting and Resolving Stalled and Stuck I/O Issues in SQL Server 2000 SP 4 is an interesting article highlighting the changes in SP4 that help to diagnose I/O issues. At Microsoft UK in Reading, we have a scalability lab configured to allow customers to come for a week and measure their application performance in an isolated environment. The goal often includes helping to identify and solve performance issues. I’ve seen a few customers start the week with massively I/O bound databases and this will provide additional information when we look at this. It will also be great for PSS to help diagnose I/O issues remotely, which can be a time consuming process. Beyond that, of course, it will help customers to identify and solve these problems independently.