Solved

Trying to figure out how to rebuild HP DL380 raid arrays.

Posted on 2009-04-09
6
1,005 Views
Last Modified: 2012-05-06
I recently assumed a role where I am responsible for the database server.
This database is SQL 2005 with MS Dynamics 10 running on top of .it, running server 2003.
 I was looking at the configuration and noticed that all 8 drives are setup as raid 5, the performance is terrible.

I was thinking in my limited experience that a mirrored primary C:// drive with the other 4 in a raid 5 configuration? Not sure waht hte other 2 drives would be doing.

Am i mislead and to lead the database running raid 5? If I am correct in wanting to reconfigure the server what is the best way to change the production server after hours to the appropriate or optimal configuration?
0
Comment
Question by:manelson05
6 Comments
 
LVL 3

Expert Comment

by:dmathwizard
ID: 24112881
If its critical the server must be up at all times or most of the time then leave it alone. If not and there is about 12 hours of no access then your plan sounds good but something in the back of my mind says they did that for a reason.
0
 
LVL 6

Expert Comment

by:Thomas Wheeler
ID: 24112926
are you just getting bad performance from the raid? what raid card are you using in the DL380?
0
 

Author Comment

by:manelson05
ID: 24112997
The raid card is the integrated 200 raid controller.
I am not understanding why they would have set up the entire server with a massive C drive.

Is it not more efficient, better performance to have the os on one set of drive and then ahve the raid take all the paging hits?
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 22

Expert Comment

by:65td
ID: 24115003
If the box is paging it probably requires more RAM.
0
 
LVL 55

Accepted Solution

by:
andyalder earned 500 total points
ID: 24115216
RAID 5 write performance isn't good, half the speed of RAID 10 assuming the same number of disks.

It isn't clear which generation of DL380 you have, you say 8 disks which would imply a G5 but then you say the option of changing it to two mirrored plus 4 others which is only 6 disks which could be a previous generation. I'm guessing that the 200 RAID controller is an E200/128 BBWC since the E200 doesn't support RAID 5.

You would certainly be better off splitting 2/6 with the OS, pagefile and logs on the first two and the data on the other 6, all using RAID 10. 2 for the OS, 2 for the logs and the rest for data is preferable but you don't have many disks.


Windows 2003 will not have formatted the disk very well by default, it mis-aligns the sectors. You should use diskpart to align to a 64K boundary - http://support.microsoft.com/kb/929491/en-us. At the moment each read is spanning 2 disks probably.

If you can't get it going fast enough by adding RAM and re-designing the disks and you're sure it is the disk subsystem that is the bottleneck then buy an external enclosure and lots more disks. This will also give the benefit of a better RAID controller since the e200 is an entry level one, you can get a P800 plus MSA70 for a good external shelf.

If you had more disk bays you could also migrate the RAID level by adding disks but that win't get around the align problem.
0
 

Author Closing Comment

by:manelson05
ID: 31568799
I am going to get everything backed up, add another processor, Memory to 16Gb, Server 2008, reinstall, raid 10. May consider Virtualisation with 2 machines, base os Svr 2008 and ENG server on Virtualised 2003 server dedicated.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

More or less everybody in the IT market understands the basics of Networking, however when we start talking about Storage Networks, things get a bit dizzier, and this is where I would like to help.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

747 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

12 Experts available now in Live!

Get 1:1 Help Now