Solved

RAID Configuration best prwctice on HP DL360 G7 Server

Posted on 2013-11-15
11
1,246 Views
Last Modified: 2016-12-08
I’m building a SQL 2008 Server on a HP DL 360 G7 server with five 300GB SAS drives.  It has capacity for 3 more drives.

What best practice in terms of RAID configuration from the start?

I will have logical drives as follows:

1 for OS
1 for Database
1 for Logs.

Wold I be advised to have one array @ RAID 5 for all?  Or split the OS onto another array.
0
Comment
Question by:DHPBilcare
  • 4
  • 3
  • 2
  • +2
11 Comments
 
LVL 19

Expert Comment

by:strivoli
ID: 39650627
I would use 1 RAID6 + 1 spare. RAID6 uses 2 disks for parity and is more reliable than RAID5. With RAID6 and 1 HDD as spare you "loose" 3 HDDs. As a result you obtain "only" 600GB. I would buy 3 more HDDs in order to have more room and increase performance.
0
 
LVL 35

Expert Comment

by:Mahesh
ID: 39650631
You can have 2 drivers in raid -1 (Mirrioring) - keep reserved for OS
For rest of the drives, you can configure raid-5 - keep Database and Logs
If you want to add more 3 drives then you will have option of Raid-6 as well.
The difference between Raid-5 and Raid-6 is as below.
Raid-5 have one parity disk (sustain failure of 1 disk)
Raid-6 have dual parity (Sustain failure of 2 Disk)
0
 

Author Comment

by:DHPBilcare
ID: 39650633
I have to build the server today thus can add more drives to a RAID 6 after its created?

Whats the min number of drives for RAID 6?
0
 
LVL 35

Expert Comment

by:Mahesh
ID: 39650652
Four
0
 

Author Comment

by:DHPBilcare
ID: 39650653
How does one array, all drives @ RAID 6.

Should give me 900GB usable.

Is it wise to include Windows, Data and logs in the same array?
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:DHPBilcare
ID: 39650655
I'm happy being able to stay up with a two disk failure.
0
 
LVL 19

Expert Comment

by:strivoli
ID: 39650656
You can add more drives to a RAID 6 depending on the RAID CTRL itself. Usually it allows expanding a RAID Array.
RAID6 requires a minimum of 4 HDDs.
0
 
LVL 19

Expert Comment

by:strivoli
ID: 39650667
Yes you'll get 900GB.
Win/Data/Logs in the same Array? If you had several disks (10 or more) I would have created more Arrays but in your scenario 1 Array is the only solution. I don't see any problems with a single Array.
0
 
LVL 19

Expert Comment

by:Miguel Angel Perez Muñoz
ID: 39650813
RAID configuration must depends of I/O of database. Remember RAID 5 have poor performance on write operations (because needs calculate parity and write on disk) and lot of little transactions on disk causes performance may be rubbish.

RAID 1/RAID 10 may offer better write performance to databases and better fault tolerance.
0
 
LVL 55

Expert Comment

by:andyalder
ID: 39651063
RAID 6 write performance is even worse than RAID 5 write performance plus you need the Smart Array Advanced Pack licence to use it. I'd use RAID 1 for the OS and unless the DB is very write intensive I'd put the transaction log volume on that pair of disks too, then use RAID 5 or 10 for the data.

You can change RAID levels on the fly assuming there is enough space that's not taken up with logical drives but that requires battery/flash backed write cache.
0
 
LVL 19

Accepted Solution

by:
strivoli earned 500 total points
ID: 39651454
Since you have 5 HDDs of 300GB with an option for further 3, consider that your solutions are:

RAID1: add a 6th drive and you can create 3 Arrays of 300GB each. Each Array can have only 1 HDD failed.
RAID10: add a 6th drive and you can create 1 Array of 900GB (same space as previous scenario but much more flexible). It is built linking 3 pairs of RAID1. You can have only 1 HDD failed for each pair.

RAID1 for OS: use 2 HDDs and get 300GB.
RAID5 for Data: use the remaining 3 HDDs and get 600GB. OR...
RAID10 for Data: add a 6th HDD and you can get a 600GB Array.

The choice should be done based on many factors but the most used are:
a. Space needed,
b. Disk I/O expected,
c. Reliability. I've used tens of Arrays and the most secure, in my opinion, is RAID6.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now