How to Create and Configure Load Balancer for AG Listener in MS Azure - SQL Server HA on Azure

How to Create and Configure Load Balancer for AG Listener in MS Azure

How to Create and Configure Load Balancer for AG Listener in MS Azure explains all below steps.

1. How to create load balancer in Azure Portal?
2. How to Configure Internal Load Balancer in Azure? 
3. How to Configure FrontEndIP of Load balancer in Azure?
4. How to configure backend pool in Load balancer in Azure?
5. How to configure Health Probes in Azure?
6. How to configure Load Balancer for Availability Group Listener in Azure?
7. How to Configure AG listener port in Load Balancer in Azure? 
8. How to Configure Cluster to use Load balancer in Azure?

Script Used in this video: 

$AG = Get-ClusterResource | Where-Object { $_.resourcetype -eq "SQL Server Availability Group" }

$Listener = Get-ClusterResource | Where-Object { $_.Name -like $AG.Name + "*" -and $_.resourcetype -eq "Network Name" }

$IP = Get-ClusterResource | Where-Object { $_.Name -like $AG.Name + "*" -and $_.resourcetype -eq "IP Address" }

Get-ClusterResource $IP.Name | Set-ClusterParameter -Multiple @{"ProbePort"="80";"OverrideAddressMatch"=1;}

Get-ClusterResource $Listener.Name | Set-ClusterParameter -Name "PublishPTRRecords" -Value 1

Get-ClusterResource $Listener.Name | Set-ClusterParameter -Name "HostRecordTTL" -Value 60

How to Create and Configure Load Balancer for AG Listener in MS Azure