You have a Microsoft SQL Server Always On availability group on Azure virtual machines.
You need to configure an Azure internal load balancer as a listener for the availability group.
What should you do?
You have a Microsoft SQL Server Always On availability group on Azure virtual machines.
You need to configure an Azure internal load balancer as a listener for the availability group.
What should you do?
To configure an Azure internal load balancer as a listener for a Microsoft SQL Server Always On availability group, enabling Floating IP is necessary. This setting ensures that the IP address can float to another virtual machine within the availability group, which is essential for high availability and failover scenarios.
Floating IP is correct, used for SQL always on availability. The probe uses TCP, not HTTP. https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-load-balancer-portal-configure
thanks for explanation
D. Enable Floating IP.
Create an HTTP health probe on port 1433 - Health probe must be configured on TCP. Set Session persistence to Client IP - Specifies that successive requests from the same client IP address will be handled by the same virtual machine. This setting is not required to configure for MS SQL always on. Set Session persistence to Client IP and protocol - Specifies that successive requests from the same client IP address and protocol combination will be handled by the same virtual machine. This setting is not required to configure for MS SQL always on. Answer is D