Skip to main content
TechNet
sys.availability_read_only_routing_lists (Transact-SQL)
 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012) noAzure SQL Database noAzure 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.

Applies to: SQL Server (SQL Server 2012 through current version.
Column nameData typeDescription
replica_iduniqueidentifierUnique ID of the availability replica that owns the routing list.
routing_priorityintPriority order for routing (1 is first, 2 is second, and so forth).
read_only_replica_iduniqueidentifierUnique 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 has been granted some permission. For more information, see Metadata Visibility Configuration.

Entity with relative path '../Topic/AlwaysOn%20Availability%20Groups%20Dynamic%20Management%20Views%20and%20Functions%20(Transact-SQL).md' can not be found, for source topic '{"project_id":"7d6ffa79-2ddc-4606-b774-a6a5d46784cd","entity_id":"0686bc5a-c206-41ef-b40a-79a8259d51d2","entity_type":"Article","locale":"en-US"}'.
Entity with relative path '../Topic/AlwaysOn%20Availability%20Groups%20Catalog%20Views%20(Transact-SQL).md' can not be found, for source topic '{"project_id":"7d6ffa79-2ddc-4606-b774-a6a5d46784cd","entity_id":"0686bc5a-c206-41ef-b40a-79a8259d51d2","entity_type":"Article","locale":"en-US"}'.
Monitor Availability Groups (Transact-SQL)
Entity with relative path '../Topic/AlwaysOn%20Availability%20Groups%20(SQL%20Server).md' can not be found, for source topic '{"project_id":"7d6ffa79-2ddc-4606-b774-a6a5d46784cd","entity_id":"0686bc5a-c206-41ef-b40a-79a8259d51d2","entity_type":"Article","locale":"en-US"}'.