AppDynamics for Databases

2.9.x Documentation

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Custom Email Body: Optionally specify the body content of the email alert. 

Example: Alert on Tablespace Usage

To avoid getting running out of tablespace on a tables you can setup a custom SQL alert in AppD4DB that would run a SQL query to monitor the tablespace.

You can use SQL similar to the following to return tablespaces where auto_extend is turned off, and the free space % is less than 10%. You can tweak these parameters as required. Note that the logic for this alert is included in the SQL (i.e. the < 10%) therefore you can set a threshold of 0 when you create the Custom SQL alert. If the SQL returns anything, then it will automatically trigger the email notification.

...

Examples

Custom SQL Alerts (Oracle)

Custom SQL Alerts (SQL Server)