Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sys.availability_read_only_routing_lists (Transact-SQL)

SQL Server 2012

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.