Solved

RAID Configuration best prwctice on HP DL360 G7 Server

Posted on 2013-11-15
11
1,341 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 36

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 36

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
 

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

In this article you will get to know about pros and cons of storage drives HDD, SSD and SSHD.
Concerto Cloud Services, a provider of fully managed private, public and hybrid cloud solutions, announced today it was named to the 20 Coolest Cloud Infrastructure Vendors Of The 2017 Cloud  (http://www.concertocloud.com/about/in-the-news/2017/02/0…
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 …
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

786 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