In order to review the failovers of AG, you can use the following command in SSMS ;WITH cte_HADR AS (SELECT object_name, CONVERT(XML, event_data) AS dataFROM sys.fn_xe_file_target_read_file(‘AlwaysOn*.xel’, null, null, null)WHERE object_name = ‘error_reported’)SELECT data.value(‘(/event/@timestamp)[1]’,’datetime’) AS [timestamp],data.value(‘(/event/data[@name=”error_number”])[1]’,’int’) AS [error_number],data.value(‘(/event/data[@name=”message”])[1]’,’varchar(max)’) AS [message]FROM cte_HADRWHERE

Continue ReadingView Availability Group failovers