Hello All,
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 In Advance.
Ryan HuntThe following link will answer your questions,
http://www.sql-server-performance.com/sql_server_performance_audit2.asp|||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%?
Thanks
Ryan Hunt
没有评论:
发表评论