# Formulas to Calculate RAID Performance?

Discussion in 'Performance Tuning for Hardware Configurations' started by DBADave, Sep 22, 2003.

What formula exist to calculate RAID performance? I would like to compare RAID 0+1, 5 and 10. I know the forumla deals with I/O per second, but I don't recall its syntax.

Thanks, Dave

3. ### gaurav_bindlishNew Member

The book MicrosoftÂ® SQL Server 2000â„¢ Performance Tuning Technical Reference @http://www.microsoft.com/mspress/books/4944.asp has excellent discussion on this topic.

Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

5. ### ykchakriNew Member

RAID 0:

I/Os per Disk = (Reads + Writes) / Number of Disks

RAID 1:

I/Os per Disk = [Reads + (2*Writes)]/2

RAID 5:

I/Os per Disk = [Reads + (4*Writes)] / Number of Disks

RAID 10:

I/Os per Disk = [Reads + (2 * Writes)] / Number of Disks

That's exactly what I was looking for. How did you find this information?

Thanks, Dave
7. ### joechangNew Member

in raid 1 or 10, 1 logical write requires 2 physical disk writes
in raid 5, 1 logical write require 1 physical read of the data block, 1 read for the parity, 1 write for the data, 1 write for the parity for a total of 4 I/Os

Thanks for the help.

Dave
9. ### TangoNew Member

Hi ykchakri and all!

In the RAID 10 formula, by "number of disks" do you mean physical or logical disks? That is, if I have a 4 disks RAID 10 array, do I have to count 4 (for the physical disks), or just 2 (for the 2 mirrors that build the RAID 10 volume)?

Thanks.

quote:Originally posted by ykchakri

RAID 0:

I/Os per Disk = (Reads + Writes) / Number of Disks

RAID 1:

I/Os per Disk = [Reads + (2*Writes)]/2

RAID 5:

I/Os per Disk = [Reads + (4*Writes)] / Number of Disks

RAID 10:

I/Os per Disk = [Reads + (2 * Writes)] / Number of Disks

10. ### joechangNew Member

the formulas apply to actual physical disks, not the physical disks in Windows Disk Management.

Suppose you have a HW RAID controller, Use the Windows physical disk counters (MS seems to suggest the logical counters are expensive to maintain)

the performance counters the Operating System reports is for the logical drive presented by the RAID controller.
So, if the OS reports 100 reads and 100 writes from a RAID 10 logical drive,

the IO going to the actual physical drives is: 100 for the reads, and 200 for the 100 writes (100 for each part of the mirrored set)
11. ### TwanNew Member

Also remember that the stripe size for RAID is significantly smaller for RAID 5 then other forms of RAID, making the read/write performance even worse

Cheers
Twan
12. ### MityaNew Member

and what about RAID15? how is the perfomance calculated?
13. ### Luis MartinModerator

Mitya, welcome to the forums.