cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
pclark
AppDynamics Team (Retired)

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
Last update:
‎11-19-2018 02:19 PM
Updated by:
Contributors