So I have been tasked with building a replacement SQL server for our very old SQL2000 based server. The current server only has a few hard drives (no RAID, 3 drives, 1 for OS, 1 for log and one for data), 2GB of memory, using dual Xeon CPU's. Since this is a massive point of failure, I want to replace this server as soon as possible with a 2008 based configuration. While I am not 100% set yet on the server itself (thinking about a HP DL180 or better, with dual power supplies), I want to focus on the drives.
I am not a SQL administrator, I am just the IT guy, but want to get the drive layout right. This is what I have in mind:
RAID1 array (OS + SQL software + misc. data) - 2 drives
RAID5 array (SQL data) - 4 drives
RAID10/5 array (SQL log files) - 4 drives
RAID1 array (SQL tempdb, not sure about the best RAID solution for this volume) - 2 drives
Since I am trying to get a system supporting 12 2.5" 10,000RPM SAS drives (either 146GB or 300GB, depending on price), what laying would you recommend? Currently the DB is around 40GB.
As for memory, I am looking at 8GB or more.
Are there any other gotcha's I should worry about?
I did do some research, and read through some older articles, but wanted to make sure I don't miss any major issues. Thanks!