I will be replacing an old windows 2003 server for a new client. As it is a smaller office with 11 workstations, I would like to use an HP ML310e which is an entry level server. I need to support a optometry software database which currently replies on SQL 2008 R2. My question is what RAID configuration would you suggest I use? Most of the ML310e units but with a B120i controller which supports raid 1 and I believe 10 as well. High end variations of server are available with a true RAID P420 controller. I don't want to spend the client's money needlessly however. Here are some options I am considering:
#1: B120i - 2 Sata 7200 disks RAID 1
#2: B120i - 4 Sata 7200 disks RAID 10
#3: B120i - 1 Sata enterprise SSD
#4: P420 - 2 SAS 15K Disks
Recommendations anyone? Thank you!