Always OnAavailability Group Read Traffic

Question

Always OnAavailability Group Read Traffic

jdbrown239

SSCarpal Tunnel

Points: 4393
More actions
September 3, 2020 at 11:51 pm

#3786162
Does anyone know of any good references on how to direct application reads and SSRS reads between the primary and read-only replicas? I would like to have all application reads go to the primary and not the read-only replica.
- This topic was modified 4 years, 2 months ago by jdbrown239.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

You would have to set the connection application intent to readwrite for the application and readonly for SSRS and ensure you have the proper read only routing setup in the AOAG configuration.

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-read-only-routing-for-an-availability-group-sql-server?view=sql-server-ver15#:~:text=To%20support%20read-only%20routing%2C%20the%20availability%20group%20must,That%20is%2C%20they%20must%20be%20read-intent%20connection%20requests.

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover?view=sql-server-ver15