Steve Tilkens (@stevetilkens) reviews the process to build a Microsoft SQL Server cluster (Windows Server Failover Cluster) on vSphere and the configurations required to tune the workload for performance.
NOTE: This video is roughly 60 minutes in length so it would be worth blocking out some time to watch it!
Helpful Links
Microsoft SQL Server on Windows Server Failover Cluster (WSFC) on VMware vSAN – New Capabilities! – https://blogs.vmware.com/apps/2019/10…
vSphere 7 Microsoft Windows Server Failover Cluster with Clustered VMDKs https://www.vmware.com/content/dam/di…
Disk and File Layout for SQL Server – https://cloudblogs.microsoft.com/sqls…
Performance Best Practices for VMware vSphere 6.7 – https://www.vmware.com/content/dam/di…
StorageHub – https://storagehub.vmware.com/
SQL Server Failover Cluster Instance on VMware vSAN™ Native – https://storagehub.vmware.com/t/sql-s…
Best Practices For Running VMware vSphere On iSCSI – https://storagehub.vmware.com/t/best-…
Architecting Microsoft SQL Server on VMware vSphere – https://www.vmware.com/content/dam/di…
Microsoft Windows Server Failover Clustering (WSFC) with shared disks on VMware vSphere 6.x: Guidelines for supported configurations (2147661) –
https://kb.vmware.com/s/article/2147661
Setup for Failover Clustering and Microsoft Cluster Service –
https://docs.vmware.com/en/VMware-vSp…
ESXi/ESX hosts with visibility to RDM LUNs being used by MSCS/WSFC nodes with RDMs may take a long time to start or during LUN rescan (1016106) – https://kb.vmware.com/s/article/1016106