Where to find availability group fail over occurences

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  November 14, 2014 at 10:13 am

  #312555

  Hello all,

  Where can I find dates and times to when an availability group was moved outside of the SQL error log?

  Thanks!

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  November 14, 2014 at 10:26 am

  #1758687

  Found the .xel files locally on the server ... which are accessible via the dashboard. Anyone know if there's a better way to query these?

  Thanks