Knowledge Base

cancel
Showing results for 
Search instead for 
Did you mean: 

How can I use AppD4DB to alert if a database instance goes down?

Question

How can I use AppD4DB to alert if a database instance goes down? This is not for when an OS goes down. We want to know if SQL Server crashes, for example.

 

Answer

Set up a Custom SQL Alert like this:

AppD4DB_alert.png

 

 

If the SQL Connection is successful and it can run a query then it will return a 1. If it fails then you will get an email containing the exception.

 

For example, here is the alert history:

SQL_alert_history.png

 

This is the contents of the default alert:

default_alert.png

 

Version history
Revision #:
2 of 2
Last update:
‎11-19-2018 02:19 PM
Updated by:
 
Labels (1)
Contributors


Found this article helpful? Click the Thumbs Up button.
Have an additional comment? Post it below.
0 Kudos