How many databases are on a basic availability group?

How many databases are in AlwaysOn availability group?

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 AlwaysOn system views and DMVs, and/or stalled dispatcher system dumps.

What is a basic availability group?

A basic availability group supports a failover environment for a single database. It is created and managed much like traditional (advanced) Always On Availability Groups (SQL Server) with Enterprise Edition. The differences and limitations of basic availability groups are summarized in this document.

Can a database belong to more than one availability group?

A given instance can host only one availability replica per availability group. However, each instance can be used for many availability groups. A given instance can be either a stand-alone instance or a SQL Server failover cluster instance (FCI).

How many replicas can I have in an AlwaysOn availability group?

Each availability group supports one primary replica and up to eight secondary replicas. For more information, see Overview of Always On Availability Groups (SQL Server). Each availability replica must reside on a different node of a single Windows Server Failover Clustering (WSFC) cluster.