I am about to deploy a new server at work as follows:
2 x Xeon 2.53 Quad core
24 GB RAM
1 x Perc H700 RAID controller with 1GB Non Volatile memory
8 x 300GB 15k SAS Hard drives
I am looking for recommendations of how to best configure this for use as a SQL server. I have the following in mind:
Allocate a 4GB RAM drive for TempDB
Group all 8 drives into large RAID 10 array for OS, Database and Log files
Allocate 4GB RAM drive for TempDB
Use some mixture of RAID arrays (but only have one controller)!
Any other suggestions!
For info, the databases in question consist: 1 x 4GB under heavy Read and Write use, 1 x 4GB clone for testing purposes, 2/3 other more minor databases.