sys.availability_read_only_routing_lists (Transact-SQL)
Returns a row for the read only routing list of each availability replica in an AlwaysOn 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
Concepts
Monitor Availability Groups (Transact-SQL)
AlwaysOn Availability Groups (SQL Server)
Other Resources
AlwaysOn Availability Groups Dynamic Management Views and Functions (Transact-SQL)