Always on Availability Groups Using Load Balancer(VNN) and Distributed Network Name(DNN)

This Video helps you to understand the differences when configuring windows cluster on 2016 and 2019. Also it helps us the DBA to understand on how to configure VNN & DNN both together in Azure.
This also covers the various scenarios in single subnet Environment. It explains Clearly why we need Load Balancer for SQL Server Always on Listener in Azure.

[@shaikhjaved7839]

APR concept was amazing, you explained well. one thing I want to add here to explain in simple way why we need Azure load balancer to work AG listener, because in "Public" Cloud APR protocal which does mapping between VM IP and MAC address is Disabled"

[@vamsychiranjeevi9619]

Hello Javed sorry need to correct you it's not APR . It is ARP (Address Resolution Protocol). If you are on a single Subnet then you have to use either Load Balancer (VNN) or Distributed Network Name (DNN). This is because Gratuitous ARP will not work in any Cloud.

[@roshanak3307]

​@@vamsychiranjeevi9619 how does that arp things get sorted out with multi subnet?

[@vamsychiranjeevi9619]

@@roshanak3307 Well on Multi Subnet we need not worry about this as SQL knows where to fail it over because of the "OR" Dependency. When it comes to Single subnet it doesn't know where to failover with out the support of Load balancer.

[@roshanak3307]

@@vamsychiranjeevi9619 thanks, but still i have a question, why cant we use the OR in single subnet? Allocate 2 ips to each node from the same subnet..there is something else

[@burropoco]

This video is so technically excellent! I've watched many Azure Deep Dive webinars from Microsoft that were not as detailed as this.

[@vamsychiranjeevi9619]

That's a big compliment.

[@mainoddinkhazi5148]

Really a nice video you have made. This would be very much helpful for the DBA who actually started working on azure platform side.. Hope You are doing well bro..

[@vamsychiranjeevi9619]

Glad it was helpful!

[@fledgedfortune5383]

Thank you for the detailed demo. Plz share the link for multi-subnet video.

[@vamsychiranjeevi9619]

Well, out of 130 videos I uploaded 40 in Public mode. If you need others contact me on my WhatsApp [phone]

[@erichrockman4852]

Hello. Love your videos. I am very interested in the multi-subnet failover for AG. Will you be releasing a video on the topic? Thank you.

[@vamsychiranjeevi9619]

Hi Erich, This is part of my training. In case you are interested ping me on my WhatsApp [phone]

[@srinivask8904]

Hi Vamsy, thanks for sharing this video. This is really helpful. Does Distributed AG supported in Azure?

[@vamsychiranjeevi9619]

Yes it does

[@sergiys8006]

Hello
what about '' The WSFC IP address also needs to be on the load balancer.' ?

[@vamsychiranjeevi9619]

Yes it needs to be

[@10101881]

Hi Vamsy, do you provide job support?

[@vamsychiranjeevi9619]

Well, Can you ping me on my WhatsApp [phone]?