[AlwaysOn2017] DMV and DMF-Sys.availability_read_only_routing_lists of AlwaysOn
6 、 Sys. Availability_read_only_routing_lists
Returns a row for the read-only route list for each availability copy of the AlwaysOn availability group in the WSFC failover cluster.
Column name
Data type
Description
Replica_id
Uniqueidentifier
A unique ID that has an available copy of the route list.
Routing_priority
Int
Priority order of routes (1 for the first level, 2 for the second level, and so on).
Read_only_replica_id
Uniqueidentifier
The unique ID of the available copy to which the read-only workload will be routed.
