Home > IT Answers > Storage > Deciding on a RAID Level for a 64-bit SQL Server 2005
SQL Server Ask the Experts
2,585 pts.
 Deciding on a RAID Level for a 64-bit SQL Server 2005
RAID, RAID Level 1, RAID Level 1 +0, SQL Server 2005, SQL Server 2005 (64-bit)
I need to install SQL Server 2005 (64-bit) on two new servers, but these servers have only four hard disks with 500GB each. From what I understand, all my operating systems, data and log files will reside on these four disks. I have two choices: to use RAID Level 1 or Level 1 +0. Which RAID level do you suggest, and how much RAM should I need for this server?

Software/Hardware used:
ASKED: March 5, 2009  8:22 PM
UPDATED: March 6, 2009  10:35 PM
RELATED QUESTIONS
Answer Wiki:
RAM is dependant on the application that you are running. But since you have 4 drives, I would suggest raid 1+0. That would give you 1 TB of disk space. The RAID level that you select will depend on what kind of load you'll be placing on the database. If you are using a low IO database application then either RAID 5 or RAID 0+1. If a higher write application then RAID 0+1. This article covers the various <a href="http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1262122,00.html">RAID types</a>.
Last Wiki Answer Submitted:  March 6, 2009  1:15 am  by  mshen   27,325 pts.
All Answer Wiki Contributors:  mshen   27,325 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi Mshen,
Thank you very much for your response.

Maylee63
 30 pts.