December 11, 2017 at 6:33 am
In an organisation I found the following setup:
Six VM SQL1 to SQL6 in the same domain, each host two instances. They are in four AG groups.
AG1:
SQL1\INS1, SQL3\INS1, SQL5\INS1
AG2:
SQL1\INS2, SQL3\INS2, SQL5\INS2
AG3:
SQL2\INS3, SQL4\INS3, SQL6\INS3
AG4:
SQL2\INS4, SQL4\INS4, SQL6\INS4
However, all the AG groups are in one Windows failover cluster CLUS1. I would like to hear your opinions and pros/cons to have all AG groups in one cluster (license cost, perfromance, high availability and etc.)
* They don't use Failover Cluster Instance of SQL Server. Only AG groups and Windows Server Failover Cluster.
Many thanks!
December 13, 2017 at 5:58 pm
An AG allows failing over multiple database at the same time for example if the are interdependencies.
December 14, 2017 at 9:18 am
already answered and discussed here
https://www.sqlservercentral.com/Forums/1912286/Multiple-AG-groups-in-one-Windows-failover-cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply