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
 General SQL Server Forums
 New to SQL Server Administration
 RAID recommendation for sql server

Author  Topic 

revdnrdy
Posting Yak Master

220 Posts

Posted - 2011-06-29 : 11:42:05
Hello;

I am interested to know what RAID settings your sql server should use. I am more concerned with performance than redundancy. I am just looking for a general idea of what people use.

We are setting up our servers on a new san that was just installed. The server will have windows server 2008 & sql server 2008 dedicated to sharepoint db's. The server will be part of a small sql cluster once configured.

It seems like raid 1+0 is the best for performance but I also see where factors like the raid controller design, cache & speed of hard disk becomes a factor. We are also looking at raid 50.

thanks.

r&r

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2011-06-29 : 12:02:54
Here are two resources well worth reading:

http://www.miracleas.com/BAARF/RAID5_versus_RAID10.txt

http://www.kendalvandyke.com/2009/02/disk-performance-hands-on-part-5-raid.html
Go to Top of Page

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-07-01 : 08:33:01
USE Raid 10 ,if you have a cost constraint then go to Raid 5

Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2011-07-05 : 04:22:49
quote:
Originally posted by Jahanzaib

USE Raid 10 ,if you have a cost constraint then go to Raid 5

Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com


Thats not very good advice without an explanation. I would rather the OP read the links and make up their own minds than blindly follow that piece of advice.
Go to Top of Page
   

- Advertisement -