Friday, February 24, 2012

How to calculate AVG. Disk Queue Length

Hi All,

we have collected perfmon data for a specific lun. Here is the background of the lun. The lun is Raid10 with 4 physical disks. We have problems interpreting the data. In the perfmon counter screen we have a max of 435 and average of 0.512. Can somebody tell us what is that we are missing? Any help is greatly appreciated.

Thanks,

Venkat.

In theory the 'magic' number for avg. disk queue length is 2 per spindle.

There are however counters which are more interesting like avg. disk sec/read and avg.disk sec/write which should be below 20ms for data disks and below 3ms for log disks.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

thanks for answering. Remember, when you look at the PerfmonCounters, you always have them in units as 1.00 or 100. how do you correlate those units with the actual readings you are seeing?

|||

The value is always in the unit the counter mentions. The graphs can have a different scale and this can be changed through the properties.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

No comments:

Post a Comment