Any suggestions? Export (0) Print
Expand All

sys.availability_read_only_routing_lists (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

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.

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.

Community Additions

ADD
Show:
© 2016 Microsoft