Replication Factor 2 (RF2) refers to the number of copies of data written in the cluster. When RF2 is enabled, the Nutanix Distributed File System (NDFS) will create two copies of the data, resulting in higher levels of data durability and availability. Reference: https://portal.nutanix.com/page/documents/details?targetId=Advanced-Administration-v5_7:aa-ndfs-rf2-c.html

An administrator can create VM Protection Policies to enforce VM to host affinity for each VM in the AHV cluster. This will ensure that the VMs are always running on the same host, even if the cluster is resized or the VMs are migrated to other nodes. This is the most efficient way to achieve the desired goal. Reference: https://portal.nutanix.com/page/documents/details?targetId=Prism-Admin-Guide-v5_6:pr-vmprofiles-affinity-c.html

In a Nutanix environment, the product or feature most suitable for deploying a Microsoft SQL cluster is Nutanix Objects. Nutanix Objects is a S3-compatible object storage solution that provides a highly scalable and durable storage for unstructured data. It is built on top of the Nutanix Distributed File System (NDFS) and provides a high-performance, scalable, and highly available storage solution.
One of the key features of Nutanix Objects is its ability to support Microsoft SQL Server Always On Availability Groups (AAG) on S3 object storage. This allows you to deploy a highly available SQL cluster on Nutanix, with the ability to failover SQL services to a different node in the event of a failure, and provide high availability and disaster recovery for SQL databases.