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.


4
0
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

Description

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: 


	select
	ag.name, 
	stat.replica_server_name as if_server_primary, 
	lis.routing_priority, 
	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.