This question has been asked in different ways before, most recently here:
RAID 5 vs RAID 10 in drive array for SQL Server Database (is the performance boost really huge with RAID 10?)
We are setting up a newSQL Server now with
2 36GB SCSI drives for the OS (mirrored - RAID 1)
4 72GB SCSI drives for Data and Applications (RAID ????)
The server is a HP ProLiant DL380G4p High Performance Dual 3.4GHz 2GB RAM (we will most likely add RAM, at least 1 GB). We can't add more drives, there are only 6 bays so the only way to increase capacity later would be to replace the drives with bigger ones.
We were planning to turn the 4 drives into a RAID 5 and then partition this drive into 2 logical drives. But now I am hearing that for better performance we should use RAID 10?
My main question is: is the performance boost really huge?
We are a small company (about 100 computer users) with about 50 people accessing the SQL datatbases regularly. We are expecting a big boost in performance by switching to this new server from a 6 year old server. Three main SQL based applications on this server:
Microsoft Dynamics Solomon - heavily customized
Goldmine (CRM package)
Attendance Enterprise (time management system with 4 time clocks, punches primarily early am and around 4 pm - batch processed)
Each of these databases are 2 - 4 GB in size and growing.