Forum Discussion

lucjad's avatar
lucjad
Icon for Neophyte rankNeophyte
11 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
lucjad's avatar
lucjad
Icon for Neophyte rankNeophyte
11 months ago

Most likely issue is the ping not resolving to the right IP address. 2 devices in Logic Monitor are added as Listeners- they are both multi-subnet Listeners- ping is trying to hit one of the secondary IPs instead of online listener IP. So it just fails until TTL expires and it retries and we get lucky it starts to ping the right IP address until TTL expires and retries again. 

Mike_Moniz's avatar
Mike_Moniz
Icon for Professor rankProfessor
11 months ago

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.