We help IT Professionals succeed at work.
Get Started

RAID configuration question for MS GP.

Wayne88 asked
Last Modified: 2016-10-27

I have read many postings about MS SQL server raid configuration but I am getting many recommended solutions so I thought I post the question here.

First off, the server is a DELL T710 with 24gb of RAM and 8 300gb hard drives and we are rolling out a new SQL Server 2008 for our new ERP system (MS Great Plains) which will be accessed by 40-50 users.

According to Microsoft the following setup is recommended:

RAID1: O/S & applications
RAID1: SQL Database log files
RAID5: SQL Data files

After reading some of the postings, most recommended RAID10 so I assume the setup will be as follow (please correct me if I am wrong):

RAID1: O/S & applications
RAID1: SQL Database log files
RAID10: SQL Data files

Now to add a little twist to this, I was speaking to a DELL specialist about a different system configuration. We were thinking about going with a high availability system but did not because it's too costly.  The setup is still similar in a sense that there will be a storage array that can meet the required recommended configuration above but he said to me that was the old way of configuring it.  The new way and more common these days is to just do one big Raid10 for everything so I am more confused at this point.

Hopefully, you can shed some light and let me know what you think is best from your experience considering good failover, speed and of course ease of restoration (disaster recovery, we use Acronis).

Thank you,

Watch Question
This problem has been solved!
Unlock 2 Answers and 5 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE