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 views0 comments

Recent Posts

See All

SQL Server 2012 Availability Groups Lessons Pt 8

This is the eighth tip on SQL Server 2012 availability groups (AG) to help you understand what else you need to consider in creating a high availability environment with AG. Tip 8: Like database mirro

70

SQL Server 2012 Availability Groups Lessons Pt 7

This is the seventh tip on SQL Server 2012 availability groups (AG) to understand their configuration and setup. Tip 7: In our current setup we have an AG with a primary and two synchronous secondarie

40

SQL Server 2012 Availability Groups Lessons Pt 6

This is the sixth tip on SQL Server 2012 availability groups to make sure CDC works. Tip 6: Change Data Capture (CDC) has been around since SQL Server 2008, but now you need to incorporate CDC with SQ

50