brother_of_karamazov
Legendary Poster
From http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops6.mspx :
Note on Disk Queue Length
This counter no longer yields meaningful results in interpreting disk I/O problems
with SQL Server 2000. This is because the SQL Server engines dynamically manage disk
I/O, which is why the Max Async I/O setting no longer exists. A simplified explanation
is that SQL Server issues an order for disk I/O, but does not wait for that process to
complete before issuing another request. When the I/O request has completed its work,
the database engine is notified and processes the results. SQL Server monitors the
throughput on these requests, and will manage the amount of I/O that the disks can
effectively handle.
Thoughts?
Note on Disk Queue Length
This counter no longer yields meaningful results in interpreting disk I/O problems
with SQL Server 2000. This is because the SQL Server engines dynamically manage disk
I/O, which is why the Max Async I/O setting no longer exists. A simplified explanation
is that SQL Server issues an order for disk I/O, but does not wait for that process to
complete before issuing another request. When the I/O request has completed its work,
the database engine is notified and processes the results. SQL Server monitors the
throughput on these requests, and will manage the amount of I/O that the disks can
effectively handle.
Thoughts?