QuestionQ124

VerifiedImplement and manage virtual networking

Your company has a Microsoft SQL Server Always On availability group configured on their Azure virtual machines (VMs).

You need to configure an Azure internal load balancer as a listener for the availability group.

Solution: You create an HTTP health probe on port 1433.

Does this solution meet the goal?

Explanation

An Azure internal load balancer for a SQL Server Always On availability group listener must use a load-balancer health probe configuration supported by the Windows Server Failover Cluster and listener setup. Microsoft guidance for SQL Server availability group listeners on Azure virtual machines uses a TCP health probe on a dedicated probe port, with corresponding cluster parameters configured for the listener. An Azure Load Balancer HTTP probe marks an instance healthy only when it returns an HTTP 200 response, and an HTTP probe on port 1433 is not the required listener probe configuration, so it does not satisfy the goal.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!