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


  1. Excellent Post as always and you have a great post and i like it thank you for sharing

    โปรโมชั่นGclub ของทางทีมงานตอนนี้แจกฟรีโบนัส 50%
    เพียงแค่คุณสมัคร Sclub กับทางทีมงานของเราเพียงเท่านั้น
    สมัครสล็อตออนไลน์ >>> goldenslot
    สนใจร่วมลงทุนกับเรา สมัครเอเย่น Gclub คลิ๊กได้เลย

    1. Great Article Cloud Computing Projects

      Networking Projects

      Final Year Projects for CSE

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

  2. Thanks for the info And I hope to read this good article again.

    เว็บไซต์คาสิโนออนไลน์ที่ได้คุณภาพอับดับ 1 ของประเทศ
    เป็นเว็บไซต์การพนันออนไลน์ที่มีคนมา Gclub Royal1688
    และยังมีหวยให้คุณได้เล่น สมัครหวยออนไลน์ ได้เลย
    สมัครสล็อตออนไลน์ได้ที่นี่ >>> Golden slot
    ร่วมลงทุนสมัครเอเย่น Gclubกับทีมงานของเราได้เลย


  3. اعالى الخليج تقدم افضل خدمات نقل العفش الدولى المتميزه باسعار متميزة ومنها :

    شركة شحن عفش من الرياض الى دبي
    نقل عفش من الرياض الى الاردن شحن عفش من الرياض الى الاردن

  4. This really helps. Thanks for posting this.

  5. The essay is not always read, alas. Sometimes written work is needed "for show". However, it is on such jobs that you should learn - the ability to write my essay correctly express thoughts will still come in handy for you.

  6. Often the okinawa flat belly tonic product is made up of lots of fuses which were very therapeutic for trimming back on abnormal bodyweight inside a few minutes. The product gets rid of stubborn fat deposits as well as all digestive system factors in a efficient direction. People with expectations to be aware of okinawa flat belly tonic in addition to points senses liberal to have a look at this valuable
    web site.