Read-only Replica -AG

Read only replica is a great concept where we can re-direct all the read only connections to that replica.

 

Following are some of the great articles for it.

How to Configure Read-Only Routing for an Availability Group in SQL Server 2016

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/active-secondaries-readable-secondary-replicas-always-on-availability-groups?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-read-only-access-on-an-availability-replica-sql-server?view=sql-server-ver15