Home Dashboard Directory Help
Search

Read only routing list - UI by Billy_La


Status: 

Active


4
0
Sign in
to vote
Type: Suggestion
ID: 776879
Opened: 1/18/2013 2:19:47 AM
Access Restriction: Public
0
Workaround(s)
view

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
Details
Sign in to post a comment.
Sign in to post a workaround.