Monitoring Always On AGs

• Kwisatz78

  SSChampion

  Points: 12478

  More actions

  February 19, 2013 at 9:57 am

  #270992

  Hi all

  I was just wondering what kinds of things people were monitoring when it came to AGs. At the moment I am thinking about creating a job to check the DMV sys.dm_hadr_database_replica_states for things such as synchronization_health and putting something together with the LSNs.

  Any input welcome

  Thanks

• Zubius

  Old Hand

  Points: 321

  More actions

  February 19, 2013 at 1:21 pm

  #1589354

  Here are a couple links that should help;

  http://msdn.microsoft.com/en-us/library/ff877954.aspx

  http://www.mssqltips.com/sqlservertip/2573/monitor-sql-server-alwayson-availability-groups/

  Along with the info provided in those, I've also set up jobs to notify me if sql agent stops/restarts and a trigger to email me when there has been a failover.

• Kwisatz78

  SSChampion

  Points: 12478

  More actions

  February 20, 2013 at 4:18 am

  #1589501

  Thanks for that, the powershell blog looks good