Read only routing list - UI - by Biljana Lazic

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 776879 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 1/18/2013 2:19:47 AM
Access Restriction Public


Since Read_Only_Routing is getting more and more important, an user interface for this topic, would be very helpful. 
I'm refering especially to viewing/crosschecking the already configured ROR, maybe with an edit option.

As an example: 

	stat.replica_server_name as if_server_primary, 
	stat2.replica_server_name as read_only_server,  
	ar.read_only_routing_url as read_only_routing_url
from sys.availability_read_only_routing_lists lis
inner join sys.dm_hadr_availability_replica_cluster_states stat ON  lis.replica_id=stat.replica_id
inner join sys.availability_groups ag on stat.group_id=ag.group_id
inner join sys.dm_hadr_availability_replica_cluster_states stat2 ON  lis.read_only_replica_id=stat2.replica_id
inner join sys.availability_replicas ar on lis.read_only_replica_id = ar.replica_id
order by if_server_primary, routing_priority
Sign in to post a comment.