Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    39

    Unanswered: Disk Activity Audit - important metrics??

    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 Hunt

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Disk Activity Audit - important metrics??

    The following link will answer your questions,

    http://www.sql-server-performance.com/sql_server_performance_audit2.asp

  3. #3
    Join Date
    Aug 2003
    Posts
    39

    Re: Disk Activity Audit - important metrics??

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •