Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2009-04-09
6
Medium Priority
?
1,013 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 7

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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 22

Expert Comment

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

Accepted Solution

by:
andyalder earned 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Hyper-convergence systems have taken the IT world by storm and have quickly started to change our point of view of how the data center should and could be architected. In this article, I’ll explain the benefits of employing a hyper-converged system …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

636 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