Availability Group Event IDs

• Jon.Morisi

  SSChampion

  Points: 12846

  More actions

  April 10, 2012 at 11:25 am

  #391987

  Hi,

  I'm planning on setting up alerting for Availability Groups via SQL Alerts on Event IDs, unless anyone has a better suggestion? (WMI?)

  I've been able to manually watch the app log and pull a list of related events.

  1480

  19406

  35202

  35266

  35267

  35299

  41074

  41093

  I'm having trouble finding a MS article listing the specific Always On Event IDs (I don't want to miss any). Has anyone see such a list?

• Jon.Morisi

  SSChampion

  Points: 12846

  More actions

  April 10, 2012 at 11:39 am

  #1471384

  Add

  -namespace "root\Microsoft\SqlServer\ComputerManagement11"

  -class HADRServiceSettings

  ...to the list of Documentation I'm looking for

• Grant Fritchey

  SSC Guru

  Points: 399061

  More actions

  April 11, 2012 at 4:59 am

  #1471753

  I haven't tried setting up an alert, but I have set up monitoring using some of the DMOs available. This Book Online entry lays out a bunch of the options.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning