We're setting up a new Hyper-V server, primarily to host a SQL Server VM, and the question came up, how much advantage is there if we used two RAID controllers instead of one? For the responsiveness of SQL Server, that is.
Physical drive setup would be:
- Data drive RAID 10
- Log drive RAID 1
- TempDB drive RAID 1
- OS/App drive
- Drives for other VMs
This would be a Hyper-V box, with a Sql Server VM. Sql Server VM would be the only one with a VHDX on those Data/Log/TempDB drives.
Would there be any advantage to spreading them out over two RAID controllers as opposed to one? How much? And if so, how would you divide Data, Log, and TempDB drives between the two controllers?