Read-only Routing

Read-only Routing is a built-in facility where a connection string to a SQL Server Availability Group can read data from a Secondary Replica instead of the Primary Replica. A connection string flag is used to signal a read-only intent.