Create alert when SolarWinds remote SQL DB is unavailable

richardjmcintosh

We had our SQL server go down over the weekend, but were not alerted to any issues since the Database for SolarWinds was on that box.  We already have plans to cluster this, but in the mean time how can I send an email alert when the Solarwinds database itself is unreachable?

jangliss

The problem you  have with creating the alerts in SolarWinds is that without the database, the alert engine cannot poll for alert statuses.  We had a similar issue with MSMQ problems a while back (see here).  Somebody came up with a crafty solution using VB and simple task scheduler, which can be found here.  You'll probably find that in the event the database was unavailable, the MSMQ counts were high on the pollers, so monitoring for that condition outside of SolarWinds will be your solution, short of setting up a second SolarWinds with a different database server.