Best RAID for Database Server

5 pts.
Tags:
Database servers
Intel Xeon
RAID
RAID configuration
We have 70+ users connecting almost 125 machines to connect to an Intel 5000VSA 4dimm Board Server with 2 Xeon processors, 6 SATA (on-board RAID 0, 5 or 10), 1 IDE port. I want to put the best possible RAID with 200/250GB SATA drives, with Best Redundancy and Performance, irrespective of the cost. Also, is it advisable to install an IDE drive for OS, and create RAID on all 6 SATA ports? I would like to have atlest 400GB for Backups, and 200GB for the Active Database. Please advise..

Answer Wiki

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

If your primary goals are performance and redundancy therefore best cost unaware raid must be raid 0+1
This gives you max write performance on a zero stripe with full mirror for redundancy.

If your really serious about true production get rid of the SATA as MTB (Mean Time Between Failure)is not as good as SAS, better perf and life over SATA, 3GB throughput on the decent drives.

Dont put IDE on a production server if you can help it as failure rate is high, this machine is a 24x 7 machine I take it, if money is no object consider a HP/Dell/IBM …… server which is designed for full prodution and 24 x 7 running + SAS drives, your Xeons will run forever but your drives will fail first(moving parts rule)

Would you put budget tyres on a F1 and expect to finish a race.

Depends on access and application stack of course but a place I would start with unlimted budget (server only of course)

Hope this helps in some way.

Paul

Agree with Paul and I wish to add the following. For any database either new implementation or infrastructure refresh, some sort of capacity planning needs to be under taken to determine current cpu, memory, storage io/sec plus storage capacity GB needs to determined and allowance made for future growth. In your case your io subsystem really depends upon your io throughput required. If you do not have these numbers then you are really doing this by trial. Paul is right 0+1 will give you the best performance but is this io sufficient. You should also look at memory as well for example if you have excellent buffer cache hit ratio you will reduce stress on io subsystem. Also consider seperating data, index and redo logs on different spindles sets.

M Iqbal

You will also want to look into separating different parts of the database onto different RAID arrays. Data should be seperate from Indexes which should be seperate from transaction logs, which should be separate from the tempdb and so on. The more you break things apart the better it will all work.

Denny

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

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