Unanswered: Disk Activity Audit - important metrics??
I am trying to perform a performance audit on a SQL Server where I am positive my most likely bottle neck is the disks. I assume the primary metrics I should be interested in are %Disk Activity and Disk Queue Length, right?
What are the actually guidelines for these metrics? Also, Are there other perf mons I should be running against the disks?
Thanks for that link. I am a bit confused about the measurements I am seeing on %busy and Average Disk Queue length. Graphically, each metric is showing up exactly identical. In other words, I cannot see two separate lines in a line graph...they are on top of each other. Also, if I look at the numeric data for each, there are again some discrepancies. The maximum for %busy has hit as high as 205.7%. The Average queue length is coming in as ((%busy)/100), or a maximum of 2.06 (rounded). Does this sound correct? How is the percent over 100%?