1

I was looking for a solution in which my application, one which I can configure only one Listener param, if we can address multiple Availability Groups or not. I have heard of using multiple listeners for one or multiple AGs, but is it possible to use a single listener and address multiple AGs?

  • see the FAQ from Allan Hirt. – SqlWorldWide Jun 22 '17 at 6:03
  • Just to clarify - when you say multiple AGs, are you simply meaning multiple servers in an AG, or are you literally meaning something like AG1 (Primary and 3 secondaries), AG2 (Primary and secondary), and AG3 (Primary, live secondary, 2 read-only secondaries)? – RDFozz Jun 23 '17 at 15:07
3

but is it possible to use a single listener and address multiple AGs.

A listener is specific to Instance of AG so you cannot connect to multiple AG's using one listener. If you have multiple instances you have to use multiple AG's.

How do you think a single listener will manager multiple AG's now how will it know which AG to connect ?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.