Forum Discussion

DBA_Bill's avatar
DBA_Bill
3 years ago

Help Setting Up Availability Group Monitoring in SQL

Hello, first time poster, new user.

I have two groups of sql servers in availability groups. I've successfully gotten Logicmonitor to collect SQL data in the SQL Server Databases and SQL Server Global Performance data sources. I've successfully added the WSFCs and get data around the health of the cluster. However, I'm unsure what additional steps are needed for Logicmonitor to collect availability group data.

When I inspect the Microsoft SQL Server Always On data sources by selecting the show associated device option, I see my WSFCs listed as devices, but there are no instances associated with those devices.

Any tips, tricks, hints, or help would be greatly appreciated.

  • Mike_Moniz's avatar
    Mike_Moniz
    Icon for Professor rankProfessor
    3 years ago

    I don't know a ton about SQL but peeking at the DataSource code for Microsoft_SQLServer_AlwaysOnAvailabilityGroups it seems to be running the below SQL statement to get a list of instances. Might want to run that to see what it outputs, if anything, and why.

    SELECT @@servicename AS instanceName,
                                 ag.group_id ,
                                 ags.primary_replica ,
                                 ag.name  ,
                                 ag.health_check_timeout ,
                                 ag.automated_backup_preference
                        FROM sys.availability_groups ag
                        INNER JOIN sys.dm_hadr_availability_group_states ags ON ags.group_id = ag.group_id