Share via

SQL Availability Groups

Micheal Mallo 350 Reputation points
2024-11-06T07:11:57.0333333+00:00

Dear team,

We are considering to deploy SQL 2019 on three servers, one that will be hosting the active databases (around 150 databases), one for high availability and one server in the disaster recovery site. We are considering using SQL availability group, to have replicas of the primary databases on the two other servers. I would like to know how many availability groups do we have to create? Do we need to create for each database an availability group, or can we include several databases in the same group?

Regards,

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,165 questions
Accepted answer
  1. ZoeHui-MSFT 38,626 Reputation points
    2024-11-06T07:57:40.5433333+00:00

    Hi @Micheal Mallo,

    Do we need to create for each database an availability group, or can we include several databases in the same group

    Suggestion: Better no more than 100 in one AG.

    Quote from this case: availability-groups-limits There is as such no limit defined. Microsoft has tested only up to 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.

    Details you may check this thread.

    Max number of Databases in a AG group

    Prerequisites, restrictions, and recommendations for Always On availability groups

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.