Learn how to configure SQL Server clusters on AHV for maximum uptime and high availability. Discover the best practices for setting up anti-affinity rules and leveraging Nutanix’s built-in features to ensure optimal performance and resilience.
Table of Contents
Question
A SQL Server cluster has been deployed on an AHV cluster. To ensure maximum uptime, the administrator wants the SQL Server VMs running on different hosts while leveraging High Availability in case of host failure.
Which configuration would meet these requirements?
A. Configure one VM as an Agent VM.
B. Disable Host affinity rules in the cluster.
C. Create an anti-affinity rule via CLI.
D. Disable VM live migration from selected VMs.
Answer
C. Create an anti-affinity rule via CLI.
Explanation
To ensure that the SQL Server VMs run on different hosts while maintaining high availability in case of host failure, creating an anti-affinity rule via CLI is the most effective solution.
Anti-affinity rules prevent VMs from running on the same host, ensuring that they are distributed across different hosts within the AHV cluster. By creating an anti-affinity rule, the administrator can guarantee that the SQL Server VMs will always run on separate hosts, minimizing the impact of a single host failure on the overall cluster performance.
The other options are not suitable for this scenario:
A. Configuring one VM as an Agent VM does not address the requirement of running the SQL Server VMs on different hosts.
B. Disabling host affinity rules in the cluster would not actively ensure that the VMs run on separate hosts.
D. Disabling VM live migration from selected VMs would limit the ability to maintain high availability in case of host failure, as the VMs would not be able to migrate to other hosts automatically.
Therefore, creating an anti-affinity rule via CLI is the most appropriate solution to meet the requirements of maximum uptime and high availability for the SQL Server cluster on AHV.
Nutanix Certified Associate (NCA) certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Nutanix Certified Associate (NCA) exam and earn Nutanix Certified Associate (NCA) certification.