September 17, 2025 at 12:00 am
Comments posted to this topic are about the item Pushing the Limits of AGs
September 18, 2025 at 12:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
September 18, 2025 at 6:45 pm
I don't know if 12 TB is pushing the limits, but that's the largest database we currently have in an AOG.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 18, 2025 at 7:42 pm
We actually use DH2i for handling our HA/DR, but we are only hosting a few instances in that failover - roughly 30 across all of our servers - and it works pretty well. Not a clue what would happen if you threw 1000+ at it, but I imagine it would work, you'd just need to adjust the timeouts so that the instances could come back up.
Mind you, if you hired me to be a DBA for 1000+ SQL instances, one of my first tasks would be to trim down the number of instances. Combine where possible, retire where possible, and try to get the number manageable. Trying to administer 1000+ SQL instances is just asking for trouble. The monitoring solutions would probably struggle a bit too trying to get data from 1000+ instances at once.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply