Deciding on a RAID Level for a 64-bit SQL Server 2005
Home > IT Answers > SQL Server > Deciding on a RAID Level for a 64-bit SQL Ser...
SQL Server Ask the Experts
2445 pts.
0
Q:
Deciding on a RAID Level for a 64-bit SQL Server 2005
SQL Server 2005 (64-bit), RAID, SQL Server 2005, RAID Level 1, RAID Level 1 +0
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?
ASKED: Mar 5 2009  8:22 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
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 RAID types.
Last Answered: Mar 6 2009  1:15 AM GMT by Mrdenny   46795 pts.
Latest Contributors: Mshen   23535 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Maylee63   30 pts.  |   Mar 6 2009  10:35PM GMT

Hi Mshen,
Thank you very much for your response.

 
0