SQL Server Performance

Evaluating Acceptable Average Range for Performance Monitor Counters

Discussion in 'Getting Started' started by lcerni, Jan 15, 2008.

  1. lcerni New Member

    I have ran Performance Monitor and have collected the following stats for a 15 min interval. I am trying to find a web site that has the Acceptable Average Range for these values to evaluate our server. For example I found that for Object Memory-Counter Pages/sec that the acceptable average range value is "avg value < 50" and that the desired value should be low. However, I cannot find one web site with all these values together. Is there such a web site?

    Object Counter Instance Avg Min Max
    LogicalDisk Avg Disk Queue Length _Total 2.795 0.004 33.798
    LogicalDisk Avg Disk Read Queue Length _Total 0.044 0 0.774
    LogicalDisk Avg Disk Write Queue Length _Total 2.752 0.003 33.746
    LogicalDisk Current Disk Queue Length _Total 3 0 66
    Memory Available Mbytes --- 4735 4733 4737
    Memory Pages/sec --- 0.161 0 6.133
    Network Interface Bytes Total/sec Intel[R] PRO_1000 MT Network Connection 323545.794 158509.108 577593.126
    Paging File % Usage _Total 1.071 1.068 1.092
    Paging File % Usage Peak _Total 1.845 1.845 1.845
    PhysicalDisk % Disk Time _Total 279.532 0.0348 3379.826
    PhysicalDisk Avg Disk Queue Length _Total 2.795 0.003 33.798
    PhysicalDisk Avg Disk sec/Read _Total 0.031 0 0.432
    PhysicalDisk Avg Disk sec/Write _Total 0.011 0 0.086
    PhysicalDisk Disk Reads/sec _Total 1.031 0 13.667
    PhysicalDisk Disk Transfers/sec _Total 114.603 48.401 398.004
    PhysicalDisk Disk Writes/sec _Total 113.572 48.135 397.871
    Processor % Idle Time _Total 97.722 94.193 98.933
    Processor % Interrupt Time _Total 0.217 0.052 0.469
    Processor % Privileged Time _Total 0.779 0.391 1.667
    Processor % Processor Time _Total 2.278 1.067 5.807
    Processor % User Time _Total 1.499 0.0573 5.052
    SQLServer:Biffer Manager Buffer cache hit ratio --- 99.518 99.518 99.889
    SQLServer:Biffer Manager Page life expectancy --- 7162 7057 7267
    SQLServer:Databases Data File(s) Size(KB) _Total 29953216 29953216 29953216
    SQLServer:Databases Percent Log Used _Total 5 5 5
    SQLServer:Databases Transactions/sec _Total 101.189 53.401 147.937
    SQLServer:General Statistics User Connections --- 157 154 161
    SQLServer:Locks Lock Waits/sec _Total 0.005 0 0.133
    System Context Switches/sec --- 3157.01 1746.178 5111.325
    System Processor Queue Length --- 0 0 1
    System Threads --- 702 695 710
  2. Luke7621 New Member

  3. Luis Martin Moderator

    Anyway I don't see any issue in your counters.
  4. lcerni New Member

    Per my reading for the LogicalDiskCurrent Disk Queue Length the avg value should be less than 2 per disk. We have values Avg=3 Min=0 Max=66. I was thinking that because of this (and the values for the Context Switches/sec, etc) that we might have a potential Disk Bottleneck.

    I guess that I am evaluating the numbers improperly. Thanks for your input!
  5. satya Moderator

    The question is do you have any performance issues, if so where it is occurring and when?
  6. lcerni New Member

    Not at this moment.
    We were trying to be proactive. We heard that there could be a potential increase demand on our database server. In the past there have been issues with performance. Thus, we were trying to do our homework and be prepared.
  7. satya Moderator

Share This Page