What is the maximum number of secondary databases configuration allowed in AlwaysOn for a single database?

Question

Up to eight secondary replicas are supported, including one primary replica and two synchronous-commit secondary replicas. 31 янв. 2022 г.

How many secondary replicas are supported by an AlwaysOn availability group?

Each availability group supports one primary replica and up to eight secondary replicas.

How many databases can you have in an availability group?

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.

Is there a limit to number of databases in SQL Server?

For SQL Server, the max number of databases you can have on a single SQL Server instance is 32,767.

How many synchronous secondary replicas can I have?

Up to 8 secondary replicas, including 2 synchronous secondary replicas (SQL Server 2016) Up to 8 secondary replicas, including 2 synchronous secondary replicas (SQL Server 2017) Up to 8 secondary replicas, including 5 synchronous secondary replicas (SQL Server 2019)

Expert · Answer