Sql-server – SQL Failover Clustering with Availability Groups: Single or Multiple Databases

availability-groupsclusteringdatabase-designfailoversql server

Company wants to implement AlwaysOn SQL Failover Clustering with Availability Groups, for server level and data protection.

Are arrangements below, only possible if 1 database is on the server, or could I have multiple databases below in arrangement?

enter image description here
enter image description here

Note: First picture has 4 servers,

Second picture only has 3 failover servers. Both have availability groups.

Best Answer

Are arrangements below, only possible if 1 database is on the server, or could I have multiple databases below in arrangement?

You can have as many databases as your hardware will support which depends on workload, server size, and other general infrastructure items such as latency and bandwidth of the connections.

I've witnessed AGs that are ~20TB in size across 4 databases, AGs that had over 1,100 databases, and all values in between. Completely depends on your workload, hardware, and what you'd like to accomplish.

Related Question