AppDynamics for Databases

2.9.x Documentation

Versions Compared

Key

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

Use the Custom SQL Alert to produce alerts on any database. The Custom SQL Alert is triggered based on the output of SQL SELECT statements run in either the monitored database instance or in the AppDynamics for Databases MySQL repository. There are three types of custom SQL alerts:

  • Single Value: Returns a single numeric value which can be compared to the threshold.
  • Name/Value List: Returns a recordset of data. The threshold is usually embedded in the SQL text. If the SQL returns a recordset, then the threshold is breached and the email alert is sent. If the SQL returns an empty recordset, then the threshold is not breached.
  • Diff Results: Detects change within a set of data. This type of Custom SQL Alert runs a SQL statement and detects differences in the returned recordset. If there are any changes, then the alert will breach the threshold and the email alert is sent.

...

Custom SQL Alerts (Oracle)

Custom SQL Alerts (for SQL Server)