AlwaysOn Availability Group Alerts

In SQL Server 2014 there are 289 messages with the word 'availability'.

Run the following query:

SELECT message_id, severity, text FROM sys.messages WHERE text LIKE ('%availability%') and language_id = 1033;

Some of these are very useful for AlwaysOn Availability Group alerting.

The three standard alerts that we create are for the following messages:

- 1480 for 'Role Change'

- 35264 for 'Data movement suspended'

- 35265 for 'Data movement resumed'