Knowledge Base

cancel
Showing results for 
Search instead for 
Did you mean: 

How to Set Up an AppD4DB Alert if Database Instance Goes Down

Question

How can I use AppD4DB to alert if a database instance goes down? Not if the 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 #:
1 of 1
Last update:
‎04-17-2015 04:19 PM
Updated by:
 
Contributors
0 Kudos