- Adam Thurgar
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'