Does VMware have the same IO limitations with virtual disks as Hyper-V for SQL Server?

sqlagent007
sqlagent007 used Ask the Experts™
on
With VMWare do the VMDK files (virtual disks) have the ability to create multiple paths the the SAN controller? Allow me to provide context and background as to why I am asking.

I was recently on a project with Hyper-V and we were migrating SQL Server to a Hyper-V cluster. The customer had purchased a more powerful set of hardware for the hyper-V environment and the thought was, we are giving 2x the amount of hardware to our new SQL Servers, so we will get 2x the performance.

We fought issues for weeks upon weeks, and we finally found out that when using Hyper-V virtual disks (VHDX) files, the VHDX files have a limitation as to the amount of SCSI channels they can establish to the SAN controller. (I am not a SAN guy, so I am paraphrasing) We determined this to be true by adding a second data file to the SQL Server database and moving that data file to a new VHDX drive and the performed the backup in half the time. After speaking with Nutanix, they stated that Windows Hyper-V should directly attach to the LUNs therefore bypassing the hypervisor for the storage layer. The OS and C drive remain on the hypervisor with a VHDX file.

The VM architect stated that this was a problem with only Hyper V and the VMware does not have this problem of creating multiple IO paths from the VMDK files to the SAN controller. I am no SAN admin, but this is hard for me to understand as I think if all my SQL data files (*.MDFs) are inside a virtual container, there must be limitations on this container limiting the amount of IO my SQL data files get.

I am now in another project where the VMware architect has presented virtual disk to the SQL Server, so before I go down this same road, I just want to know if VMware does this better than Hyper-V and will actually allow multiple IO paths from the VMDK files to the SAN controller allowing my SQL data files to leverage parallel IO.

Thanks in advance experts!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017

Commented:
It seems the discussions is the difference between RAW (RDM) LUNs and Virtual Disk containers (e.g. VMDK or VHD)

does this sound like the discussions, e.g. presenting the SAN LUN direct to the VM?
sqlagent007Technology professional

Author

Commented:
Correct. We found with Hyper-V that we gained acceptable performance by having the SAN / VM team present RAW LUNs to the Guests. When we used VHD files in Hyper-V the performance was horrible for SQL Server. Once we started creating multiple VHDs and striping the SQL Server data files across multiple VHDs the performance improved. However we still ran into issues where the Windows OS was seeing 20K ms disk latency and the Nutanix show less than 3ms latency.

Now I am on a project and the VMware guy is telling me that this will NOT be an issues because VMware does this so much better than Hyper-v. I am just looking for confirmation that this is true. As my SQL brain cannot wrap my head around how VMware would be able to do performance equivalent to RAW LUNs with VMDK files.

Thanks so much for your response and let me know if I provided enough data.
VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017
Commented:
Okay, just wanted to check we were discussing the same technology.

So for years in VMware vSphere (ESX and ESXi) we were encouraged to use RDMs for Performance.....

and then announcements were made, do not use RDMs for performance VMDKs are fine!

RDM versus VMDK performance (this was reported in 2011!)

Conclusion: VMFS and RDM have similar performance. Don’t choose RDM for performance.
Source:http://www.vfrank.org/2011/03/22/performance-rdm-vs-vmfs/

As for your situation... this whitepaper/guide/Best Practice was produced in August 2018, and should be now regarded as the BIBLE ON VMware vSphere!

ARCHITECTING MICROSOFT SQL SERVER ON VMWARE VSPHERE® Best Practices Guide


This document discusses Partition Alignment, VMFS and Virtual Machine Disks for performance, it does not mention RDMs! Discusses using different VMDKs, and the use of the PV controller!
sqlagent007Technology professional

Author

Commented:
Thank you so much!!!! This is amazing!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial