Im looking to configure a new sql server with a dell r730xd 24 bay chassis and need some help with choosing the drive configuration for sql server. Need help on what to choose for our RAID configuration on the data and log drives. What will we get the best overall performance out of the machine.
Currently we have 2 databases, and would like to separate them onto their own sets of drives (data and log) to a total of 4 drive letters. They are 600gb and 500gb on the data side. Currently they are both around 20gb log files. We would like to get to 1.8tb total space for the data drives and 600gb for the log files.
We have a choice of RAID 5 with 15K drives or RAID 10 with 10K drives. the 15K drives come in 300gb and 600gb. The 10K drives come in 300gb, 600gb, 1.2tb and 1.8tb. What would be optimal for performance?