One of my friend sent an email with the requirement to load
balance the traffic coming from application to secondary SQL Server replicas in
always on availability group. Read-only routing refers to the ability of
SQL Server to route qualifying read-only connection requests to an available
Always On readable secondary replica. The
advantage of Setting the readable secondary as Read-Intent Only will allow the
secondary server to serve the read-only workload only if the connection string
of the application contains Application Intent=Readonly parameter.
Read My Complete Article posted in SQLServercentral.com "Here"
Ganapathi varma Chekuri
Email: gana20m@gmail.com
No comments:
Post a Comment