sys.availability_read_only_routing_lists (Transact-SQL)

Applies to: SQL Server

Returns a row for the read only routing list of each availability replica in an Always On availability group in the WSFC failover cluster.

Column name Data type Description
replica_id uniqueidentifier Unique ID of the availability replica that owns the routing list.
routing_priority int Priority order for routing (1 is first, 2 is second, and so forth).
read_only_replica_id uniqueidentifier Unique ID of the availability replica to which a read-only workload will be routed.


The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.

See Also

Always On Availability Groups Dynamic Management Views and Functions (Transact-SQL)
Always On Availability Groups Catalog Views (Transact-SQL)
Monitor Availability Groups (Transact-SQL)
Always On Availability Groups (SQL Server)