Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL 2014 Availability groups and listeners

Posted on 2016-10-05
5
Medium Priority
?
69 Views
Last Modified: 2016-10-05
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
Comment
Question by:Eprs_Admin
  • 3
  • 2
5 Comments
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 41829766
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
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 41829769
And each AG can have up to 8 database replicas.
0
 

Author Comment

by:Eprs_Admin
ID: 41829772
ok then I try to install a new one.
Thanks a lot.
0
 
LVL 52

Accepted Solution

by:
Vitor Montalvão earned 2000 total points
ID: 41829788
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
 

Author Closing Comment

by:Eprs_Admin
ID: 41830053
Thanks a lot.
0

Featured Post

Industry Leaders: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question