RAID configuration recomendations for new servers

Posted on 2014-03-08
Last Modified: 2016-12-08
I am converting from a single PowerEdge 2800 server that hosts Active Directory and SQL Server 2008 to a two server configuration with one acting as an Active Directory server and the other one as a SQL 2012 server. Currently there are only 15 workstations that connect to the SQL server which hosts an Impromed Infinity database.

The new SQL server is a PowerEdge R510 with the following specs:

Windows Server 2012 R2 Standard
(x8) 300GB 15K RPM SAS 6Gbps 3.5in drives
PERC H700 Integrated RAID Controller, 512MB Cache
16GB of RAM
(x2) Intel XeonE5620 2.4Ghz, 12M Cache,Turbo, HT, 1066MHz

The new AD server is a PowerEdge R420 with the following specs:

Windows Server 2012 Standard
(x8) 300GB 10K RPM SAS 6Gbps 2.5in
PERC H710 Integrated RAID Controller, 512MB NV Cache
16GB of RAM
Intel Xeon E5-2430 2.20GHz, 15M Cache

My question is what do you recommend for RAID configurations for the new AD server and SQL Server?  The new AD server will also act as a file share and will be hosting AD, DHCP, DNS, and an antivirus suite. The SQL server will be dedicated for SQL Server 2012.

Also any recommendations for the best way to configure SQL server 2012 with these hardware specs? Most of the configuration guides I see are for large enterprise installations.
Question by:BlackDogSC
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
LVL 47

Accepted Solution

dlethe earned 300 total points
ID: 39914982
For optimal performance
1x2 disk RAID1 for the O/S
1x2 disk RAID1 for tempdb/scratch table space
1x4disk RAID10 for everything else

Be sure to configure NTFS for 64KB chunk size on the RAID10, defaults elsewhere.

(More RAM would have been much better)

Author Comment

ID: 39915005
Thank you dlethe,

How much RAM would you recommend? Also any recommendations for the AD server as far as RAID config?
LVL 47

Expert Comment

ID: 39915041
More RAM = better SQL performance for most apps.  I know people who put in 512GB of RAM and it isn't enough.    If you want performance, particularly write performance, then RAID1 is way to go.  If you are read intensive, then I'd go with a 6-drive RAID6 for the data RAID1 for the O/S.    If performance isn't satisfactory, you can backup and convert the RAID6 to a RAID10.  

But RAID6 gives you 2 parity drives so you are much less likely to risk data loss in event of drive failure.
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

LVL 55

Assisted Solution

andyalder earned 200 total points
ID: 39915554
Both servers look to be overkill for 15 users.

For ImproMed Infinity I presume that X-ray images are stored on the same box rather than being linked to the general fileserver so that would imply you want a reasonable amount of data space. Apart from images the other data isn't likely to be very big. I wouldn't expect it to be write intensive since the vets will refer to patient history a lot more often than they update it.

That means that transaction log is not going to be very large nor need many IOPS so I would put the OS, applications and transaction log on a pair of 300GB disks and use the other 6 for the database and files Low write requirements imply RAID 6 for this but that doesn't mean you don't have to back the data up as well.

For the AD server/general fileserver I'd just use one logical disk over all 8 drives, Probably RAID 10 but maybe RAID 6 if you need the space.
LVL 35

Expert Comment

by:Seth Simmons
ID: 39916587
the sql server may not be overkill depending on the size of your database; 16gb seems reasonable.  i do agree your domain controller has way too much disk space.  you can get away with 2 300gb drives in a raid 1 and 8gb ram which is plenty for just ADDS roles and those network services.  don't recommend hosting an anti-virus suite on a domain controller
LVL 78

Expert Comment

ID: 39916589
The DC which you should when possible have two.
Straight raid 1 wth 4-8GB is more than enough.
Is/was virtualization considered?

Two VMs as Dcs 40GB per VM is more than enough, but andyalder pointed what you might be using, so adjusting the two VMS to include space for one to function  as a fileservers in a DFS failover configuration and then have a VM for the sql server and another as a fileserver.
The rest of the space could be ...

If you are using the express version of the database, ........

Author Comment

ID: 39920531
Thank you everyone for your help. This is becoming quite informative, and there is definately more than one way we can go here. I am not well versed with VMs, but it had crossed my mind as I see them used more and more. I will need to learn more about VMs though before I delve into them.

We are going to use SQL Server 2012 Standard edition. We may end up hosting a second database so we decided to go with standard instead of a runtime version of sql.

Our digital radio-graphs are currently stored on a dedicated PACS server which is backed up to a specialized cloud service incrementally. However we will start receiving all of our lab work digitally and any faxes we receive will also be coming in over a fax card into the DC and that will start to take up disk space.

And in case anyone was wondering, currently we backup to local ioSafe SoloPro's and perform offsite backups.

Thank you again for everyone's help. I am going to close this question although I may post another one concerning VMs.

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Query (lookup) 8 54
BranchCache not working 9 18
Ransomware case 23 89
Migrate SQL 2005 DB to SQL 2016 4 17
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

742 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