查看只读路由

select a.*,c.is_local,c.role_desc,d.endpoint_url,d.read_only_routing_url 
from sys.dm_hadr_availability_replica_cluster_nodes a
join sys.dm_hadr_availability_replica_cluster_states b
on a.replica_server_name = b.replica_server_name 
join sys.dm_hadr_availability_replica_states c
on b.replica_id = c.replica_id 
join sys.availability_replicas d
on c.replica_id = d.replica_id 

select 
 b.replica_server_name 
,a.routing_priority 
,c.replica_server_name 
from
sys.availability_read_only_routing_lists a
left join
sys.dm_hadr_availability_replica_cluster_states b
on a.replica_id = b.replica_id 
left join sys.dm_hadr_availability_replica_cluster_states  c
on a.read_only_replica_id = c.replica_id 
order by a.replica_id 

配置只读路由晚一点补上

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

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