Search
  • Adam Thurgar
    • Jul 17, 2017
    • 1 min read

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'


5 views

Recent Posts

See All