Diagnostics in SQL Server 2000 SP4 and in later versions help detect stalled and stuck I/O operation
This article discusses logic that was added to SQL Server 2000 SP4 and in later versions that helps detect stuck and stalled I/O operations. ... Indexes and parallelism Frequently, bursts of I/O occur because an index is missing. This behavior can push th...