Class AvailabilitySchema.AvailabilityReadOnlyRoutingList

sys.availability_read_only_routing_lists (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Returns a row for the read only routing list of each availability replica in an Always On availability group in the WSFC failover cluster.

[Table(Schema = "sys", Name = "availability_read_only_routing_lists", IsView = true)]
public class AvailabilitySchema.AvailabilityReadOnlyRoutingList

Properties

Unique ID of the availability replica to which a read-only workload will be routed.

[Column("read_only_replica_id")]
[NotNull]
public Guid ReadOnlyReplicaID { get; set; }

Unique ID of the availability replica that owns the routing list.

[Column("replica_id")]
[NotNull]
public Guid ReplicaID { get; set; }

Priority order for routing (1 is first, 2 is second, and so forth).

[Column("routing_priority")]
[NotNull]
public int RoutingPriority { get; set; }