Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mvanwyk
Yak Posting Veteran
99 Posts |
 Posted - 2009-06-29 : 09:21:45
|
| Hi Guys.We have SQL 2005 installed on a HP DL 380 Server Dual 2GB RAM.The MDF and LDF files are located on the D drive of the server.The Average Disk Write Queue length looks like this over a period of 10 days, is this OK?6 ms6 ms7 ms7 ms7 ms8 ms8 ms7 ms7 ms6 ms |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-06-29 : 09:49:10
|
| Those do not look like valid disk queue lengths. 6 ms is a unit of time, while a disk queue length is a count.Where are you getting these numbers?CODO ERGO SUM |
 |
|
|
mvanwyk
Yak Posting Veteran
99 Posts |
Posted - 2009-06-29 : 10:16:41
|
| Hi I'm looking at performance monitor.I might be reading it wrong then, please help.What i have is as follows.\\SERVERNAMEPhysicalDisk 0 C: D:Avg.Disk Write Queue Length 0.020 |
|
|
|
|
|
|
Avg Disk Write Queue length