Solved

RAID Configuration best prwctice on HP DL360 G7 Server

Posted on 2013-11-15
11
1,303 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
New My Cloud Pro Series - organize everything!

With space to keep virtually everything, the My Cloud Pro Series offers your team the network storage to edit, save and share production files from anywhere with an internet connection. Compatible with both Mac and PC, you're able to protect your content regardless of OS.

 

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Lets start to have a small explanation what is VAAI(vStorage API for Array Integration ) and what are the benefits using it. VAAI is an API framework in VMware that enable some Storage tasks. It first presented in ESXi 4.1, but only after 5.x sup…
Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
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 …

930 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

10 Experts available now in Live!

Get 1:1 Help Now