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)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru