Updated: June 10, 2016
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.|
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.
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)