Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 72
  • Last Modified:

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 ?
0
Eprs_Admin
Asked:
Eprs_Admin
  • 3
  • 2
1 Solution
 
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
 
Vitor MontalvãoMSSQL 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
 
Eprs_AdminSystem ArchitectAuthor Commented:
Thanks a lot.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now