Perfmon IO Data bytes/sec | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Perfmon IO Data bytes/sec

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. Thanks!

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.
Also check Avg. Disk queue length.
Luis Martin
Moderator 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.
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 />[email protected]<br /><br />When life gives you a lemon, fire the DBA.