A customer is planning to migrate their physical Microsoft SQL Server clustered workloads to vSAN enabled vSphere clusters.
The following requirements must be met:
✑ Each MSSQL cluster is made up of 3 nodes
✑ Highest possible availability against node failures
✑ Some of the vSAN clusters will only consume storage
What should the architect recommend?
To meet the requirement of the highest possible availability against node failures, the architect should recommend a Stretched vSAN Cluster. A Stretched vSAN Cluster is designed to provide high availability and site-level disaster recovery by stretching across two geographical locations. This setup ensures data redundancy and higher availability by mirroring the protected data to a remote site. Since the requirement specifies the highest possible availability and some clusters will only consume storage, a Stretched Cluster is more appropriate than the vSAN iSCSI Target Service, which primarily addresses using iSCSI for shared storage and does not directly relate to node failure resiliency.
I believe it is A as ISCSI supported MS SQL cluster as well as Oracle RAC
Physical Microsoft SQL Server
As Architect recommendation, we should recommend B. from ChatGPT
I think it's A vSAN 6.7 expands the functionality of the vSAN iSCSI Target service to provide the SCSI-3 persistent reservations support for shared disks for windows failover cluster if using the SQL Server FCI, high availability mode is a requirement. The vSAN iSCSI Target service at the vSAN cluster level should be enabled for this purpose. VSAN streched cluster may be used to increase the data availability across data centres. https://blogs.vmware.com/virtualblocks/2019/03/26/considerations-for-running-microsoft-sql-server-workloads-on-vmware-vsan/