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