Which type of RAID is better for five HDD system? And how to setting it up on HP ML350 G5 Server

Hi all,

My company had two HP ML350 G5 server with E200I 128MB RAM  that plan using Windows Server 2003 R2 64bit to be
1. Domain-Based DFS
2. MS SQL Database application with the Account System ...

Now we had five 250GB SATA Plugabled HDD ...

I hear the saleman said that our server can using the HDD to be Hot Spare ... with four other HDD be the RAID-5

I go to HP's official web site, have not find any manual that teach how to setting up like that ...

And how about the size? Make it 128K or 64K or 32K or other value while the RAID build, I had experience of using ICH6R, 7R, 8R, 9R to make RAID-0, which K is best for File Server and Database at the same machine?

I am wonder, how the Hot Spare HDD working when the system is good health, and if one HDD dead, what will happened if have the Hot Spare HDD here.

Or using total five HDD to build a RAID-5 is better or using 2 HDD make RAId-1 for Os, other 2 HDD RAID-1 for Data, one HDD for Hot Spare? Do one E200I array card can do like that?

Thank you.
explorer1979Asked:
Who is Participating?
 
Handy HolderConnect With a Mentor Saggar maker's bottom knockerCommented:
I would agree on advising agains RAID 5 for SQL, should use 2 disks mirrored for OS/pagefile, 2 mirrored for transaction logs and the rest in RAID 5 or RAID 10 for data and possibly a seperate pair for tempDB. Also I would advise strongly against using SATA, HP count these as near-line storage for backup, archiving etc.

There again you've got it now so I would use a mirrored pair for OS/programs and transaction logs and another pair for data leaving 1 disk as hotspare. You have to assign the hotspair to both arrays or it may not kick in if a disk fails. Hot spare is temporary - once you replace the failed disk it will rebuild using that and the hot-spare will be freed up again.

Default stripe size is normally correct, I'd go for 64K.

Array configuration guide is at http://bizsupport.austin.hp.com/bc/docs/support/SupportManual/c00729544/c00729544.pdf
0
 
slam69Commented:
Hi with 5 disks and using Hp I would def recommend raid 5 due to teh redundancy you can achieve with th e hot swap option. dell servers are a little dicey with hot swaps as isnt always possible but Hp work just fine. Its quite an expensive option but fanatstic once you get it up and running. Setting up raid 1 isnt going to get the most out of your system. you will want to configure this with 1hdd as your system and os partition and then 3 striped hdds and one redundant.

Check this KB

http://support.microsoft.com/default.aspx?kbid=323434&product=winsvr2003
0
 
slam69Commented:
apologise coffee hasnt jicked in yet i meant your system and os should be on different volumes lol
0
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
explorer1979Author Commented:
One RAID Card can do like that??

Do HP have any document for reference. I am first time using HP
0
 
explorer1979Author Commented:
Add to 70 point.

I want to using Hardware based RAID, since my HP Server have the E200I and we add addition money to upgrade it to 128MB RAM already.
0
 
slam69Commented:
Hi,

with reference to your other quetion i am again strongly advising against a raid 5 setup if you are using sql server.

if you still choose to do this check teh following link advice on settin gup raid 5 really good article. Some raid 5 controller card can do what you are looking for however majority of them have space for 4 drives not the 5 you have so just ensure when buying the card that you pick one with teh necessary port sapce

http://www.smartcomputing.com/Editorial/article.asp?article=articles/2004/w1510/14w02/14w02.asp

0
 
explorer1979Author Commented:
andyalder and slam69,

Thank you of your kindly reply.

Now I know the RAID-1 for OS with two HDD, the other RAID-1 for Data, plus the other disk be Hot Spare is good choose.

But, I want to ask, for a 40 person base using, not heavy load the SQL, do RAID-5 performance is poor than a standalone HDD?

And for the File Server using, RAID-1 for 250GB (Formatted will be 230GB about I thinked) it will not meet our need of the storage need.

And I readed the manual of the PDF, it is great, but what the
ACU can "Set the boot controller"
But ORCA can not.

Do I am using the SmartStart CD to boot the system, then using ACU to setting up the RAID will can not install the OS? Since it can not set the boot controller

Thank you so much
0
 
Handy HolderSaggar maker's bottom knockerCommented:
with a 4 disk RAID 5 array writeperformance is about the same as a single disk, read performance is 4 times as good as a single disk.

If you're short of space you can put 4 disks in 1 array, create a RAID 10 stripe for OS and RAID 5 array for data on the same 4 spindles. ORCA can't do this but ACU can.

Boot controller is set in BIOS/CMOS, you can change it during boot.
0
 
explorer1979Author Commented:
Add point to 100

Andyalder,

Thank you so much.

Can you give me the step by step to put 4 disks in 1 array, create a RAID 10 stripe for OS and RAID 5 array for data on the same 4 spindles.by ORCA, and using the other disk for Hot Spare on the RAID?

Thank you.
0
 
Handy HolderSaggar maker's bottom knockerCommented:
Boot the smartstart CD that came with it, select maintain server, ACU. Put 4 disks in 1 array and save, create logical disk of 16GB with RAID 10 and save again. You cannot do this with ORCA unless they have updated it recently. You can add the hot spare both physically and with the ACU under Windows later when you have finished installing OS with same CD.
0
 
explorer1979Author Commented:
Add point to 120

andyalder,

Thank you ...

But, put 4 disk in 1 array, and create logical disk of 16GB with RAID10, it is for OS?

And you said other RAID-5 for Data in same spindisk .. do then after create the logical disk of 16GB with RAID10 later, then using the other free space on this 1 array 4 HDD to create the other logical disk of XXX GB free space with RAID-5 by the ACU?

The server will arrived this afternoon, so I much know the RAID detail as soon as possible, it is my first time make like RAID-5 + RAID 10 on one RAID Card like that for new It Support like that.

Thank you.
0
 
explorer1979Author Commented:
andyalder,

E200I look like not support RAID-10 ...
On the User Manual, it just said, 0, 1 0+1 and 5, no the RAID-10 see on the E200 Manual .

http://bizsupport.austin.hp.com/bc/docs/support/SupportManual/c00711217/c00711217.pdf
0
 
slam69Connect With a Mentor Commented:
hi points still to andy but just to save you a bit of time raid 0+1 is raid 10
0
 
explorer1979Author Commented:
slam69,

Thank you very much, actually, I will give you some point for the assistant answer whatever other answer my questions or not.

So Add point is just let all other person who had help me's response :-)
0
 
explorer1979Author Commented:
Hi,

I successful using SmartStart CD 7.9 that using ACU to make the RAID 1+0, it is real easy for beginer.

But I in the ACU, see a choose "Split Mirrored Array"

What is it? Do I need do this step for better fault-tolerance? Or after the 1+0 Array maked, it is all?

Thank you.
0
All Courses

From novice to tech pro — start learning today.