RAID configuration recomendations for new servers
Posted on 2014-03-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.