Load balancing reads SQL Server 2016 AG
1
vote
2
answers
3795
views
I'm trying to balance read traffic between two SQL Server 2016 Enterprise Edition instances (Primary and Secondary) using availability groups and the read only routing.
Here is my current setup:
* The servers are in AWS in two different AZ
* The servers are in a failover cluster without shared storage
* AG is enabled on both instances
* The databases in an Availability Group have the "Readable Secondary" option set to Yes
* I've setup the AG with the read only routing on both the current primary and secondary instances
* Adding the read only switch in my application connection string allows me to route traffic to the secondary
Is there a way to have the AG Listener load balance read only traffic between the primary and secondary?
Asked by Aaron
(1802 rep)
Apr 19, 2017, 06:21 PM
Last activity: May 18, 2021, 01:29 PM
Last activity: May 18, 2021, 01:29 PM