查看唯讀路由

select a.*,c.is_local,c.role_desc,d.endpoint_url,d.read_only_routing_url from sys.dm_hadr_availability_replica_cluster_nodes ajoin sys.dm_hadr_availability_replica_cluster_states bon a.replica_server_name = b.replica_server_name join sys.dm_hadr_availability_replica_states con b.replica_id = c.replica_id join sys.availability_replicas don c.replica_id = d.replica_id select  b.replica_server_name ,a.routing_priority ,c.replica_server_name fromsys.availability_read_only_routing_lists aleft joinsys.dm_hadr_availability_replica_cluster_states bon a.replica_id = b.replica_id left join sys.dm_hadr_availability_replica_cluster_states  con a.read_only_replica_id = c.replica_id order by a.replica_id 

配置唯讀路由晚一點補上

ALTER AVAILABILITY GROUP [AGName]MODIFY REPLICA ONN'hostName' WITH(SECONDARY_ROLE (READ_ONLY_ROUTING_URL = N'TCP://192.168.?.?:port'))

ALTER AVAILABILITY GROUP [AGName]MODIFY REPLICA ONN'hostName' WITH(PRIMARY_ROLE (READ_ONLY_ROUTING_LIST = (N'host1',N'host2')));