In order to review the failovers of AG, you can use the following command in SSMS<\/p>\n\n\n\n
Be aware that when the logs are cleaned, you can not see anything.<\/p>\n","protected":false},"excerpt":{"rendered":" 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<\/p>\n Continue ReadingView Availability Group failovers<\/span><\/i><\/span><\/span><\/span>\t;WITH cte_HADR AS (SELECT object_name, CONVERT(XML, event_data) AS data
FROM 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_HADR
WHERE data.value('(\/event\/data[@name=''error_number''])[1]','int') = 1480<\/code><\/p>\n\n\n\n