Offloading read load on multiple database replicas
The problem Since the release of SQL Server 2012, Microsoft made good on their promise of easily allowing read only workloads to be routed to the secondary. This is easily achieved by configuring AG routing in such way so that by changing the application’s connection string to Application Intent=Read-only the calls will be routed to the preferred secondaries. However for many legacy (or not) applications, this is more difficult to do than it looks. It’s rare to find applications that…