MSSQLTREK

In part1, I’ve shown how to create a windows cluster in a multi subnet setup.  In this post let’s see how to create a AG and corresponding listener.

In my lab, I will be creating two AGs and two corresponding listeners.

Details:
I’ve two databases – > sales and customers.
Two AGs – > Sales_AG and Customers_AG.Two Listners – > sqllst_Sales and sqllst_Cust.
For sales AG, I’ve disabled “Database level health detection”, a new feature introduced in SQL 2016.

Now, for Listener two IPs from both subnets have been provided.

Same process has been followed for creating customers AG and listener as well(But this time I’ve enabled Database level health detection).

Since this is a multi-subnet setup two entries(one from each subnet) will be created in DNS for each listener name as shown below.

That’s about it folks.