I am currently running a physical server for my SQL 2012 R2 box. I'm planning to visualize the box to my HP SAN.
I bought a new enclosure just for this SQL VM. I've partitioned the enclosure with 3 different partitions, one for the OS, one for the data and one for the Logs. The OS and Logs volume are raid 1. The Data volume is raid 6.
I ran a performance test using the Crystal Disk Mark software: http://crystalmark.info/software/CrystalDiskMark/index-e.html
I ran the tests on my physical server and also on the raid 6 and raid 1 volumes as well.
I'm trying to figure out if there's a major difference between the raid 6 and raid 1, as I would like to keep my data with raid 6, so I don't have to use raid 10, or I will lose to much storage.
Looks to me like the physical server is faster than the VM, but there isn't much difference between raid 6 and raid 1.
Is this correct?
Will it be adequate to use raid 6 for my data volume, instead of using raid 10?, as raid 1 didn't make a big difference?