Sample Header Ad - 728x90

SQL Server 2016 Multiple Availability Groups and instances

2 votes
2 answers
8631 views
So we are getting ready to make a major architecture shift and I get to be on the hook for it, yay! Currently we have 22 separate availability groups each with their own windows cluster across 44 servers. We want to move to 6 servers to hold the 22 AGs, yes I know it doesn't divide evenly. So for example a given server (VM) would be 4 SQL Server instances, each instance would be an availability group and have its own listener. So something like: * NODE1: SQLINST1, SQLINST2, SQLINST3, SQLINST4 * NODE2: SQLINST1, SQLINST2, SQLINST3, SQLINST4 * AGs: SQLINST1, SQLINST2, SQLINST3, SQLINST4 * Listeners: SQLINST1Lis, SQLINST2Lis, SQLINST3Lis, SQLINST4Lis My questions are: * does each SQL Server instance also need to be its own windows cluster or could one cluster suffice for all the named instances? * Will this work at all?
Asked by trocheaz (165 rep)
Apr 25, 2017, 07:50 PM
Last activity: May 9, 2024, 09:15 AM