THIS TOPIC APPLIES TO: SQL Server (starting with 2012) Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse
Returns a row for the read only routing list of each availability replica in an AlwaysOn availability group in the WSFC failover cluster.
Applies to: SQL Server (SQL Server 2012 through current version.
Unique ID of the availability replica that owns the routing list.
Priority order for routing (1 is first, 2 is second, and so forth).
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.