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
Last activity: May 9, 2024, 09:15 AM