Are there any limit of Max number of Databases in a AG group? Putting many databases in a Single AG group has any consideration ?
like many log send queue/ redo threads ???
Are there any limit of Max number of Databases in a AG group? Putting many databases in a Single AG group has any consideration ?
like many log send queue/ redo threads ???
There is as such no limit defined. Microsoft has tested only upto 10 AG and 100 Databases. If you want to create more AGS, You will have to do so and test the workload you have to see that you do not land into performance issues for same.
Hi @sakuraime,
Suggestion: Better no more than 100 in one AG.Are there any limit of Max number of Databases in a AG group?
Yes. You are right. You need to consider more about its threads.Putting many databases in a Single AG group has any consideration ?>like many log send queue/ redo threads ???
If the answer is helpful, please click "Accept Answer" and upvote it.
Hi @sakuraime,
Is the reply helpful?
BR,
Mia
If the answer is helpful, please click "Accept Answer" and upvote it.
hihi. what's the formular of calculating the worker thread required for number of AG db and number of AGs , on primary and secondary ?
suppose 2AG Group , 2 replica , 10 DBs in each AG Group.
SQL Server 2016 to SQL Server 2019
4 people are following this question.