Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

[AlwaysOn2017] DMV and DMF-Sys.availability_read_only_routing_lists of AlwaysOn

2025-04-07 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

6 、 Sys. Availability_read_only_routing_lists

Returns a row for the read-only route list for each availability copy of the AlwaysOn availability group in the WSFC failover cluster.

Column name

Data type

Description

Replica_id

Uniqueidentifier

A unique ID that has an available copy of the route list.

Routing_priority

Int

Priority order of routes (1 for the first level, 2 for the second level, and so on).

Read_only_replica_id

Uniqueidentifier

The unique ID of the available copy to which the read-only workload will be routed.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report