sys.availability_read_only_routing_lists (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been 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)