Avatar of JohnnyD74
JohnnyD74
 asked on

HP ML310e RAID recommendation

Hello Folks,

I will be replacing an old windows 2003 server for a new client. As it is a smaller office with 11 workstations, I would like to use an HP ML310e which is an entry level server. I need to support a optometry software database which currently replies on SQL 2008 R2. My question is what RAID configuration would you suggest I use? Most of the ML310e units but with a B120i controller which supports raid 1 and I believe 10 as well. High end variations of server are available with a true RAID P420 controller. I don't want to spend the client's money needlessly however. Here are some options I am considering:

#1: B120i - 2 Sata 7200 disks RAID 1
#2: B120i - 4 Sata 7200 disks RAID 10
#3: B120i - 1 Sata enterprise SSD
#4: P420 - 2 SAS 15K Disks

Recommendations anyone? Thank you!
Server HardwareStorageMicrosoft SQL Server

Avatar of undefined
Last Comment
JohnnyD74

8/22/2022 - Mon
Tom F

A Lot of this depends on budget and storage space requirements.  Generally speaking, these days One Big Raid 10 is going to get your job done.  

Here's some good reading:

http://www.smbitjournal.com/2012/12/the-history-of-array-splitting/
JohnnyD74

ASKER
Hi Tom,

The budget is not a concern but I just want to make sure I spend their money wisely. Are you familiar with the B120i?
biaselectronics

Smart array (420) has the easiest and best recovery options.
You can easily swap servers and have minimal stuffing around in a critical recovery scenario.
Go smartarray if you can afford it, raid 1 with 2 disks in your question.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
SOLUTION
Tom F

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Tom F

There isn't anything complex about a RAID10 array - not to the administrator anyway.  

If budget isn't an issue and you want MUCH better performance go with 10.
Chach DalSanto

Tom F; thats my point.  He's the administrator, but what about a year or two from now?  He may have moved on, and the client will need a simple solution.  As IT people we understand the workings of RAID volumes because we do it every day.  Someone who doesn't even open their PC at home may be overwhelmed by, not 1 but 2 separate RAID functions working together intertwined, and which drive to replace, and how to trigger rebuild... etc.

15K or SSD mirror will be PLENTY of performance for 11 users.  It really will.  Even with a SQL based application.

Thx
Tom F

A non-admin isnt going to understand a RAID1 any better than a RAID10 or any other raid for that matter and chances are they won't have to.  It's really no more difficult to create or maintain a RAID1 vs RAID10 either.  

I'm not even sure why we're working under the impression there will be no admin type in the future. I'd rather plan for future growth.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Chach DalSanto

"I'm not even sure why we're working under the impression there will be no admin type in the future"

Murphy's Law.  We should plan for the worst within reason because with SMB's you never know.  Thats all.  Especially in medical facilities like this; they tend to be the WORST users because its not their training.

These are just opinions for JohnnyD74 to review, and in my experience simpler is far better. I have dozens of small businesses just like this that we maintain and being considerate of their money while delivering good performance has earned me the loyalty of all of them.  I see that you've commented on being considerate of that as well, and thats really good.  Lots of consultants aren't.  

IMHO 2 drives is just less money and less moving parts than 4 drives, so less things to break.  High throughput isn't an issue due to small user base, storage sizes on hard drives are enormous these days, and if he really wants high performance the SSD's are just as reliable as traditional HDD's.  This server could easily be expanded in the future through additional internal drives, or even external USB drives at a later date if and when they become necessary.  No need to buy them 8-12TB raw if they are never gonna use more than 500GB, and JohnnyD74 is the only one who can answer that with his client.

JohnnyD74 can review our opinions and decide whats best for his client, and how he wants to proceed with them.  Both solutions we've discussed will do the job, they are both good opinions, and even the cost difference wouldn't be major.  I simply haven't read anything leading me to believe that they NEED or would BENEFIT very much from a more complex setup... thats all.
Tom F

I understand planning for the worst, but sometimes we have to make certain assumptions.  Assuming someone will be available to admin a server is one of those assumptions - otherwise we shouldn't be installing a server at all.

2 drives is less money than 4, obviously, but you're only going to be getting half of the space from a RAID 1 setup.  You are only get half in a RAID10 as well, but you have twice the number of drives, so for twice the money you have twice the space essentially making it a wash.

Just some things to consider as well.
Chach DalSanto

Not really a wash; Either solution can be sized correctly from the beginning.  2 larger drives are going to be less expensive than 4 smaller drives.  

We're starting to split hairs.  Obviously we see things differently here; lets not argue it anymore.  Let him decide whats best for his client at this point and make his recommendation.

JohnnyD74, can you chime in on their current storage requirements (total data they're keeping on the old server) as well as what they anticipate to grow by?  Add a good safety factor to that growth, and thats how much storage you can reasonably predict they'll need in the foreseeable future.

TWISI, this decision is not so much of a technical one anymore, as much as a business one.  They'll only want to buy what they can reasonably need in the foreseeable future.  Don't overbuild.  Just because they may say the budget isn't a concern, but believe me... as a small business owner myself, it is always scrutinized.

JohnnyD74, let me throw this out as well... If larger, mirrored SSD's or 15K SAS drives with the 420i push the price up too much, can always go with WD Raptor drives.  10K rpm, SATA interface, large caches.  A great compromise between low cost inexpensive drives and high end performance drives.  I have run them in several workstations and servers with no problems for up to 8 years (just retired 2 big MacPro workstations and their server I built with them back in 2007) and the performance was fabulous.  No errors, no SMART warnings even after 8 years of non-stop 3-shift use.  

Don't be afraid to be creative.  Hope it goes well for you.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Tom F

LoL, obviously we will let him decide.   We do have a difference (and a fairly small difference) of opinions here and that's what it's all about.  I'm not 'arguing' I was simply pointing out another consideration.  

Good luck Johnny, and to answer your multiple choice question, based on what we know, my answer would be #2.
JohnnyD74

ASKER
Thank you so much guys for your insight! I will likely so with the RAID 10 solution.