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)
 RAID configuration for SQL server 2005

Author  Topic 

jung1975
Aged Yak Warrior

503 Posts

Posted - 2008-09-22 : 16:30:51
what is the best raid configuration for SQL server 2005? It;s going to be Data Warhouse environment ( ETL + Reports) ...

the server will have 400GB X 4 disk drives and intergrated D RAID 1 / RAID 10 controller..

I am planning on going with RAID 10 and would ilke to hear from other people's experience..Also, are there any documentations from Microsoft that I can reference to why RAID 10 is the best for SQL server?


lepeniotis
Yak Posting Veteran

75 Posts

Posted - 2008-09-23 : 06:10:08
Why don't you have a look on this
http://ieeexplore.ieee.org/iel5/11120/35635/01690237.pdf?tp=&isnumber=&arnumber=1690237 this is about SAN and the following is about Raid

http://articles.techrepublic.com.com/5100-10878_11-6058975.html

http://whitepapers.techrepublic.com.com/abstract.aspx?docid=284975

I don't know if these help you to come to a conclusion! I hope they help!

MSc Advanced Computing Science
MSc Database Professional
Sheffield Hallam University
MCP (70-229, 70-228)
Industrial IT Engineer
Go to Top of Page
   

- Advertisement -