I have been trawling the web for hours trying to decided what will be best for a new SQL Server that I'm setting up, but I'm struggling to find scenarios similar to mine.
Here's what I have:
- 6x 10K SAS drives connected to a single Dell Perc 6i RAID controller.
- 3x databases to be migrated to the server, each with just 5-10 users and all users primarily entering data. The databases (.mdf files?) are all less than 5GB each in size and do not grow much more than a few hundred MB /year.
n.b. Server 2008 R2 and SQL Server 2008 R2
I have read a lot about optimal raid configuration and data/file placement and as such, with what I have, what raid configuation would you reocmmend and where should I place the OS, Log Files (.ldf?), Binaries, TempDB, Data (.mdf?), and have I missed anything?. Furthermore, with the exception of the OS how and when do I specify where each of the aforementioned are placed? As you can see, I'm a bit clueless, and so appreciate your patience and understanding for a one-man-band trying his best to drag our kit into the C21.
My Current Thoughts:
RAID-1 consisting of:
- Logical Drive C: OS, Binaries
- Logical Drive D: TempDB, Log Files (ldf files), Windows Swap File
RAID-10 consisting of:
- Logical Drive E: Date (mdf files)