sys.availability_read_only_routing_lists (Transact-SQL)
Applies to: SQL Server
Returns a row for the read only routing list of each availability replica in an Always On 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. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Always On Availability Groups Dynamic Management Views and Functions (Transact-SQL)
Always On Availability Groups Catalog Views (Transact-SQL)
Monitor Availability Groups (Transact-SQL)
Always On Availability Groups (SQL Server)
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin