SQL 2014 Availability groups and listeners

Hi Experts,

I am using two big SQL servers in one AG.
And I have one Listener for the DBs.

Now I have to copy some more DBs. Is it possible to create another AG with a new listener ?
If yes how many AG are possible and how many Listeners ?
Eprs_AdminSystem ArchitectAsked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
Found this MSDN article and it states the following:
"Maximum number of availability groups and availability databases per computer:
The actual number of databases and availability groups you can put on a computer (VM or physical) depends on the hardware and workload, but there is no enforced limit. Microsoft has extensively tested with 10 AGs and 100 DBs per physical machine. Signs of overloaded systems can include, but are not limited to, worker thread exhaustion, slow response times for availability group system views and DMVs, and/or stalled dispatcher system dumps."
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
It supports multilple AGs and Listeners but I'm not aware of the maximum of them are allowed.
Mind that you can only have at maximum 2 synchronous replicas and a maximum of 9 replicas (syncs + asyncs).
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
And each AG can have up to 8 database replicas.
0
 
Eprs_AdminSystem ArchitectAuthor Commented:
ok then I try to install a new one.
Thanks a lot.
0
 
Eprs_AdminSystem ArchitectAuthor Commented:
Thanks a lot.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.