Simple Question (I hope)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Quiggley - 23 Feb 2005 15:53 GMT

SQL writes faster to a Raid 5 or Raid 1? It reads faster from a Raid 1
correct?

Reply to this Message

Steve Thompson - 23 Feb 2005 17:32 GMT

> SQL writes faster to a Raid 5 or Raid 1? It reads faster from a Raid 1
> correct?

As I recall writes are faster to RAID-5 because these writes are distributed
among multiple drives.

Steve

Reply to this Message

Sue Hoegemeier - 23 Feb 2005 20:06 GMT

A Raid 5 write incurs 4 I/Os (two reads and two writes) and
a Raid 1 write incurs 2 I/Os (two writes)
Read performance is not really as impacted by your Raid
level as write performance. Some of the read performance,
capacity depends on the number of disks in a Raid 5.

-Sue

>SQL writes faster to a Raid 5 or Raid 1? It reads faster from a Raid 1
>correct?

Reply to this Message

Steve Thompson - 28 Feb 2005 14:51 GMT

> SQL writes faster to a Raid 5 or Raid 1? It reads faster from a Raid 1
> correct?

You'll want to read this link:
http://www.sql-server-performance.com/q&a38.asp

The answer is not a simple one...

Steve

Reply to this Message