April 16, 2003 at 11:48 am
The SQL operation guide says the following
----------------------------------------
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.
-------------------------------------------
Does this mean i should not bother about this at all ?
thanks
-srini
April 17, 2003 at 5:15 am
With the engine changes you effectively do not know what else is to be qued and thus the data does not have a meaningfull value with regards to troubleshooting. So no this would not be a usefull item to look at.
April 17, 2003 at 12:28 pm
Thx.Wanted to confirm with the SQL folk/guru(s)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply