Forum Discussion

lucjad's avatar
lucjad
Icon for Neophyte rankNeophyte
5 months ago

SQL Server Ping critical alert shows up and clears

I have a SQL Server Listener (part of AG). It has Ping critical alert showing up and clearing. It is happening every 20 or 30 minutes. I attach the screenshot.  It clears and it's good for a while a...
lmproduct
Mike_Moniz's avatar
Mike_Moniz
Icon for Professor rankProfessor

You can change the device in LM to use IP addresses instead of fqdn in the "IP Address/DNS name" field.

I'm assuming "mutli-subnet listeners" means the server is multi-home and has multiple nics/ips which allow it to connect to different subnets without routing.

lucjad's avatar
lucjad
Icon for Neophyte rankNeophyte
5 months ago

So the problem is that I can't assign one IP because every time there is a failover it will switch between those 2 IP addresses and if there's just one IP assigned to device in Logic Monitor and it will pick other IP from the subnet it will recognize it as incorrect. FQDN of listener resolved Host Status issue but didn't resolve the Ping issue. 

  • Mike_Moniz's avatar
    Mike_Moniz
    Icon for Professor rankProfessor
    5 months ago

    Perhaps you need to make the collector multi-homed too? So it is also on both subnets and can reach either IP. Or you may need to install the collector software on the listener server itself. I would suggest the former though.