SQL Server Performance

Perfmon IO Data bytes/sec

Discussion in 'Performance Tuning for Hardware Configurations' started by burningcoals, Mar 1, 2005.

  1. burningcoals New Member

    Hi Everyone,

    I am having some SQL performance issues. I am running RAID 5 on HP G2 Cluster array controller. I know RAID 1+0 is much better for performance, but we didnt have the budget.

    IO's might not be related to my SQL performance problems. CPU is always at idle.

    My question is;

    Monitoring my IO Data bytes/sec I am sometimes averaging 249732.860, most the time I average 12000.000 - 20000.000. Do you know what acceptable IO's would be for a RAID 5 configuration with 15k drives?

    This is on a 2003 SQL Cluster.


  2. satya Moderator

    Can you idently when and where the performance is affected, if it is by slow running query then you can take help of PROFILER and also capture other PERFMON counters for further assessment. Good indexes and optimization will help the performance gain on large queries.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. Luis Martin Moderator

    Also check Avg. Disk queue length.

    Luis Martin

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell

    All postings are provided “AS IS” with no warranties for accuracy.

  4. derrickleggett New Member

    If you're going to pull those counters, just do the whole thing. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] Pull the Avg Read/Write Disk Queue Length under both physical and logical disk counters. Also pull the pages/sec to see what you memory looks like. How many disks are in the RAID 5 array? How much RAM do you have?<br /><br />MeanOldDBA<br />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.

Share This Page