Cross V-Net AlwaysOn AG in Azure

Derek Rhoda 1 Reputation point
2022-09-01T10:09:16.717+00:00

Hi Everyone
I have the following AlwaysOn setup in Azure
3 Servers:

Server 1 & Server 2 are in the same region within the same subnet/VNet
Server is in another region on its own subnet

When I created the cluster, it created it with a DNN automatically.
What happens with the load balancers now?
Can you have load balancers with a DNN cluster?

What would I need to do to get the AlwaysOn listener to work?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,584 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. CathyJi-MSFT 21,066 Reputation points Microsoft Vendor
    2022-09-02T08:33:03.217+00:00

    Hi @Derek Rhoda ,

    You do not need Azure Load Balancer when you have DNN. You can configure a DNN listener for AG.

    A distributed network name (DNN) listener replaces the traditional virtual network name (VNN) availability group listener when used with Always On availability groups on SQL Server VMs. This negates the need for an Azure Load Balancer to route traffic, simplifying deployment, maintenance, and improving failover.

    Please refer to below MS document to get more information.

    Tutorial: Prerequisites for availability groups in multiple subnets (SQL Server on Azure VMs)
    Tutorial: Configure an availability group in multiple subnets (SQL Server on Azure VMs)
    Configure a DNN listener for an availability group


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments

  2. Derek Rhoda 1 Reputation point
    2022-09-02T09:08:38.423+00:00

    Hi @CathyJi-MSFT

    I understand this but what happens in the case where the cluster spans VNets?