Return
-
Title
SQL Server Availability group data not collecting -
Description
The Foglight SQL Server agent shows no availability group data under HADR and the Infrastructure agent did not display as being tied to the SQL Server agent. -
Cause
An infrastructure agent using an incorrect hostname was present in the system. -
Resolution
Similar to cluster monitoring in SQL Server, an infrastructure agent for the hosts where the primary and secondary replicas are located should be present and monitoring in Foglight.
The issue was resolved when the correct Infrastructure agent was created and database agent was able to take data from its topology.