SolarWinds poller losing connectivity to Database

We have faced this issue twice in 15 days, One of our APE suddenly loses connectivity to the DB.

After troubleshooting for 4-5 hours, It just resolves on it's own. We have checked with the server team, network team and firewall team. They do not report any issue.

My guess is port 1433/1434 suddenly get blocked.

What do i do?

Find more posts tagged with

connectivity_issues

Database

npm

ape

Accepted answers

All comments

mark.gover

Might be worth logging a support case for this one. Sounds like very strange behaviour. Either that or roll out a new APE and move nodes from the problematic APE to the new.

chad.every

This is not something common that I've see out there but I talked with another customer a few years ago who deployed NetPath on their APE's and pointed it to their database port (1433). They eventually discovered that there were experiencing some occasional packet loss. I'm curious if you do the same if it can find anything network related happening.

bobmarley

When mine lose database connectivity, they post an event 4001 in the event logs. Take a look for those events and if you are seeing then there is some network issue with the connection between the poller and the SQL server.

vinay.by

Do you see any Problems, Potential Issues etc in Settings -> My Deployment -> Deployment Health ? If so can you let us know what those are ?