Deciding on a RAID Level for a 64-bit SQL Server 2005

Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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>.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Maylee63
    Hi Mshen, Thank you very much for your response.
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following