AG Availability mode changed from Asyn to Synchronous

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  May 17, 2022 at 8:20 pm

  #4034519

  Hello

  Is there any good query available to find when the AG mode is changed from Async to Sync? Unable to easily find it from the errorlog.

  Any good Tsql to filter the data would be helpful.

  Thanks.

• Johan Bijnens

  SSC Guru

  Points: 135370

  More actions

  May 18, 2022 at 12:08 pm

  #4034930

  Did you check default trace and/or system_health xe session ?

  You can monitor your AG(s) with extended events:

  ref: https://tracyboggiano.com/archive/2017/07/monitoring-availability-groups-part-3-extended-events/

   

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me