If a Microsoft SQL Server 2008 Standard Edition server is configured as below, does option 1 provide an advantage over option 2?
- 32GB RAM
- 2 x Xeon 7460 (6 core)
- Windows Server 2008 Standard SP2
- Microsoft SQL Server 2008 Standard SP1
- 2 x 146GB 15K RPM HDD in RAID 1 (for Operating System)
- 2 x 146GB 15K RPM HDD in RAID 1 (for Logs)
- 4 x 146GB 15K RPM HDD in RAID 10 (for Data)
Configure one virtual disk on the RAID 10 and use one filegroup
Configure two virtual disks on the RAID 10 and use two filegroups
Common sense tells me that there would be no speed advantage as the RAID 10 is still only able to read/write at the same speed.
Can someone advise if common sense prevails or if there is a reason I have overlooked why this would be advantageous?