Monitoring Always On AGs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL 2012 - General » Monitoring Always On AGs

Monitoring Always On AGs

Rate Topic

Display Mode

Topic Options

Author

Message

Kwisatz78

Posted Tuesday, February 19, 2013 9:57 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 7:46 AM
Points: 542, Visits: 1,402

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

Post #1421736

Zubius

Posted Tuesday, February 19, 2013 1:21 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 03, 2013 6:30 AM
Points: 9, Visits: 157

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.

Post #1421828

Kwisatz78

Posted Wednesday, February 20, 2013 4:18 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 7:46 AM
Points: 542, Visits: 1,402

Thanks for that, the powershell blog looks good

Post #1422019

« Prev Topic | Next Topic »

Permissions