Reading DISK READ/WRITES per second

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Reading DISK READ/WRITES per second

Author

Topic

sqldba20
Posting Yak Master

183 Posts

Posted - 2008-07-11 : 13:14:12

Folks:

I have got the statistics on SQL 2005 for AVG. DISK READ/WRITES per second but would like to know what is the bottom line (how do we know we are crossing the threshold?). We Use RAID 5 on SAN (12 disks) for mdf and ldf files and RAID 1 for tempdb. Here are the stats for 24 hours:

DISK 1 (RAID 5) - WRITE PER SEC : 3.82
DISK 1 (RAID 5) - READ PER SEC : 131.45
DISK 1 (QUEUE LENGTH) : 2.08
DISK 1 (BUSY PERCENT) : 59 %

DISK 2 (RAID 5) - WRITE PER SEC : 11.79
DISK 2 (RAID 5) - READ PER SEC : 490.56
DISK 2 (QUEUE LENGTH) : 24.85
DISK 2 (BUSY PERCENT) : 60 %

DISK 3 (RAID 1) - WRITE PER SEC : 12.85
DISK 3 (RAID 5) - READ PER SEC : 21.59
DISK 3 (QUEUE LENGTH) : 0.74
DISK 3 (BUSY PERCENT) : 46 %

Thanks !

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-11 : 23:34:31

Disk2 looks busy.

maninder
Posting Yak Master

100 Posts

Posted - 2008-07-13 : 00:15:51

http://www.codeplex.com/PerfTesting/Wiki/Print.aspx?title=How%20To%3A%20Identify%20a%20Disk%20Performance%20Bottleneck%20Using%20SPA1&version=6&action=Print
Try this:

Maninder
SQL server Architect / Admin (DEV&PROD)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources