Alert when SQL Monitor is having a problem.
We have the SQL Monitor database located on a different server from the Base and Web Service. We had an instance where the SQL Server hosting the SQL Monitor database went down. When that server went down it failed to send us an alerts and we didn't know that SQL Monitor was having no problems as it wasn't sending out any email alerts to notify us that it couldn't connect to it's database. A nice fix would be to have SQL Monitor send an alert to notify us that it can't do it's job.
Brian Piesik
shared this idea
This can be set-up using the 'Send base monitor error emails to' field within the Email notification settings (see attached). SQL Monitor will send error emails to this email address if a base monitor experiences an error.
-
Thomas Franz
commented
We use the free Check_MK (Nagios) for monitoring our monitor server (plus all the other windows servers). Of course it would fail to inform us, if both - the RedGate Monitor plus the Check_MK server goes down, except we would set up a third monitoring server which is monitored by no. 4 :-)
-
Hi Brian,
Just to clarify: Are you monitoring the instance hosting the SQL Monitor database? If you do and don't get any alerts, would you mind dropping a line to support(at)red-gate.com?
-
Brian Piesik
commented
I am currently monitoring it now but there is no alerts being sent that the database is down.
Easiest way to test it was to take the SQL Monitor Database offline. No events are recorded or sent to handle that situation. Can give you the Base monitor log of it happening if needed.
Brian