Server build mobo recommendation

I want to build a server with a hardware raid controller and use a CPU E5-1650 v2@ 3.50 GHz to run Windows Server 2012 or 2016.  Which Supermicro mobo would you guys recommend and which raid controller card would you recommend?  Also, what size harddrive image to build?  We will be moving 3 servers onto this machine, virtualized.  One server is DC and file server, a second server is SQL server and a third server is web server.  All three of those to go onto this new build.   Currently the drive on the DC C drive is sized at 357GB and has 124GB free space. We also have a shared drive sized at 356GB and it has 241GB free space.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Cliff GaliherCommented:
Point blank: I don't recommend building servers. Workstations yes. Servers no.
wfcrrAuthor Commented:
Cliff, please respect my request to not argue with me in this question space. I have built all our servers, for several years, and they work fine, I prefer to have comments focused on component selection and advice for building another reliable system.  I really do not want an argument in the space.
Cliff GaliherCommented:
Well, that's new.  Never considered making a recommendation as "arguing" before.   And if my advice is unwanted, I have no problems walking away from the question and wish you luck.

Before I do, indulge me this observation though:

Someone experienced in building servers would probably not be asking this question. There is a bit of a contradiction there and most experts will have a similar mindset coming into the question.  

Supermicro makes *dozens* of different motherboards for different purposes. You are asking the expert to spend valuable time reading specs when you've offered very little by way of narrowing down the search.  If you narrowed it down to two or three motherboards (and same with RAID cards) you'd have better luck.

The scant current specs and planned use doesn't help much either.  For example, you say this will have a SQL server.  Well....

A SQL server backing an inventory system for a small mechanics shop will have a lot of reads, a few writes to update counts, and *very* few writes to entire rows (new items, items no longer stocked, etc.)  That'll hit a hard drive *VERY* differently than...say....a SQL server backing a small town 911 center.   Despite its small size, 911 centers deal with all sorts of calls, all of which have to be logged (so heavy row writes), searched (heavy indexing), and have associated records (lots of blob data.)   The servers backing such systems would be VASTLY different.  Yes, I've designed/specced both throughout my career.

Computer parts are like antivirus programs.  There is no one "right" answer (or there would be only one antivirus program left standing in the market), but that doesn't mean there are no "wrong" answers.  You can get a lot of opinions on this question with very little by way to sort what is good advice and what is not.  You'll need to have the experience to narrow  the field, provide the information to avoid some of the cruft in the first place.  Based on the question, as asked, the information at least as presented is not there.

And with that, I leave you to it.  Good luck (genuinely.)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Lee W, MVPTechnology and Business Process AdvisorCommented:
So first, yes, I read your comment and your question.  LUCK is not a good way to manage servers.

It's UNWISE to build your own servers.  I used to do it.  And with experience, I've reached a point where I'd rather go buy something used on ebay than build my own servers.  I haven't done it for clients in well over a decade and I haven't done it for myself in several years.  The headaches and lack of capability is just too significant to ignore.

Question to you - when your RAID array starts going offline, who are you going to call?  Super Micro?  Seagate?  LSI?  Because if you call Seagate they'll tell you to run their diags (which likely won't be RAID aware) and then when the diags find nothing, they'll refuse to help you.  So now you call Super Micro... who ask why you are calling them, call LSI.  Who tell you to run diags and find no problem in which case, they refuse to help and tell you to call the hard drive manufacturer... Great right?  This is why you buy a Lenovo, HP, Dell, or some other pre-built, pre-tested server configuration by a major manufacturer.

LASTLY, keep in mind, you're asking a question that most professionals would not do.  So your potential answers are likely to come from inexperienced people and/or be of the sort Cliff and I provided.  What you're asking is not a common question or thing that knowledgeable people would typically do.  That doesn't mean there aren't exceptions (potentially such as yourself) but your pool of potential responses is much lower than you might like).
wfcrrAuthor Commented:
Ok.  Based on what I spec'd, what would you recommend? I placed a call to HP, requested a quote for server with 64GB ram, a raid controller and SSD's in raid 5 for 700GB HD space and a  Xeon E5 1650 CPU. They said their server would be a E5 2000 series as their mobo is a 2 socket.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Server Hardware

From novice to tech pro — start learning today.