SQL Always On - one listener for multiple AG's ?

Category: sql server dr

Question

ilikefondue on Tue, 16 Jun 2020 09:38:51


Hello, 

In a SQL Always on, can i have one listener for multiple Availibility Groups or must I have a seperate listener for each Availibility group ?

thanks


ilikefondue

Replies

Shanky_621 on Tue, 16 Jun 2020 10:04:39


Hello, 

In a SQL Always on, can i have one listener for multiple Availibility Groups or must I have a seperate listener for each Availibility group ?

thanks


ilikefondue

A listener can ONLY cater to one AG, if you have multiple AG's you need to have multiple Listeners for each of them.

ilikefondue on Tue, 16 Jun 2020 10:23:40


so its not possible to have one listener per instance and that manages all AG's in that instance? 

Shanky_621 on Tue, 16 Jun 2020 10:33:15


so its not possible to have one listener per instance and that manages all AG's in that instance? 

ilikefondue

Listener is NOT per instance but per AG to be more correct. And yes like I said above one listener for one AG ONLY

ilikefondue on Tue, 16 Jun 2020 10:33:57


thank you for your answer 

Shanky_621 on Tue, 16 Jun 2020 13:10:10


Actually it is possible.

https://techcommunity.microsoft.com/t5/sql-server/how-to-create-multiple-listeners-for-same-availability-group/ba-p/384028

Hilary the blog says multiple listener for one AG, what OP is asking is can 1 listener be used for for multiple AG's. The blog talks about where we have different subnet and you need to create one listener for each subnet