Sunday, February 12, 2012

calculating COUNTER Physical Disk: AVG. DISK QUEUE LENGTH

If I return the Average, Minimum, and Maximum values for the counter Physical Disk: Avg. Disk Queue Length, and those values are 10, 0, 87 respectively, which value do I use to compute the Avg. Disk Queue Length for a 4 disk array(RAID 10): Average, Minimum, or Maximum? The disk(lun) is on a SAN.

In theory it should be maximum 2 per spindle.

There are however other counters which are more important like Avg. Disk Sec/Read and Avg.Disk Sec/Write which should be less than 20ms (optimal) for data drives and 2-3ms for the log drive.

WesleyB

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

No comments:

Post a Comment