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. |
Permissions
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)