always on issue

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  November 18, 2015 at 9:45 am

  #309701

  we are getting issues

  Availability replica is disconnected when we checked in dashboard .

  How can we resolve this issue ?

  any query to check the endpoints configuration for the instances of the primary and secondary replica ?

• MadAdmin

  SSChampion

  Points: 11261

  More actions

  November 18, 2015 at 11:33 am

  #1840800

  Here is a list.

  Looks like they might compile the EndpointURL from bits in these queries.

  SELECT

  me.protocol_desc

  , port

  FROM

  sys.database_mirroring_endpoints AS ME

  INNER JOIN sys.tcp_endpoints AS E ON e.endpoint_id = ME.endpoint_id;

  SELECT

  ip_address

  FROM

  sys.availability_group_listener_ip_addresses;

  SELECT

  replica_server_name

  , CASE WHEN primary_replica = replica_server_name THEN 'Primary' ELSE 'Secondary' END AS PrimaryOrSecondary

  FROM

  sys.dm_hadr_availability_replica_cluster_nodes AS RepNod

  LEFT JOIN sys.dm_hadr_availability_group_states AS GS ON GS.primary_replica = Repnod.node_name;

  SELECT

  *

  FROM

  sys.dm_hadr_availability_replica_states;

  Catch-all queries done right [/url]
  Gail Shaw's Performance Blog[/url]