Setting up alerts
You can enable alerts from the monitoring profile of database connections.
To configure alerts:
- Access the console.
- In the Databases page, click the connection that you want to work on.
- Click the Summary drop-down menu and go to
. The Monitoring profile page displays.
- Click Alerts settings.
- Expand the Availability and Performance alert types, and click the
checkbox to activate the alert that you want to use. These alerts include:
After selecting the alerts, you can configure thresholds for each alert to further refine how and when alerts are generated.
- Physical memory in use
- Virtual memory in use
- Incomplete recovery
- Database availability
- File system utilization
- Table deadlock occurred
- CPU time
- Rows read
- Rows returned
- Statement performance
- Total activity time
Hover over the cell that aligns with the alert you want to configure and click Configure
A pop-up box opens, with options for setting thresholds for information, warning, and critical alert types.Note: Not all alert thresholds ares configurable, some alerts use fixed threshold.
- To set your alert options, click OK.
Click Save to save your selections to your monitoring profile. Note:
For "Table deadlock occurred" alert, you need to enable data collection. Go toand make sure that the locking status is "Enabled". Locking event monitor is disabled by default.
For "Statement performance" alert, you need to enable historical data persistence. Go to, and make sure "persistence" is "ON". Historical data persistence is ON by default.