Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Monitoring Always On AGs Expand / Collapse
Author
Message
Posted Tuesday, February 19, 2013 9:57 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:00 AM
Points: 590, Visits: 1,582
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
Posted Tuesday, February 19, 2013 1:21 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 8:35 AM
Points: 13, Visits: 272
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
Posted Wednesday, February 20, 2013 4:18 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:00 AM
Points: 590, Visits: 1,582
Thanks for that, the powershell blog looks good
Post #1422019
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse