My company is in the process of installing a new SQL server which will support 30-40 users during the workday. The server will run two databases, which are estimated to grow to a total of 50GB after 5 years. I have six 146GB SAS drives to work with.
Everything I've read indicates that, with the disks available, I should go with a Raid 1 for the OS and SQL install and a RAID 10 for the data and logs.
If there will be far more disk activity on the RAID 10 array, would I be better off going with a single 6 disk RAID 10. A 6 disk RAID 10 will outperform the 4 disk RAID 10, correct?