Custom Alerts Library

Overview

Custom Alerts enable a user to execute SQL statements or stored procedures against the Monitored database or Ignite repository database to check for customized, site specific conditions and generate an Alert when these conditions are met.  Any parameter that can be returned to Ignite using a SQL or stored procedure can be used as the basis for a Custom Alert.

How to Create Your Own Custom Alerts

For more information about Writing Custom Alerts, see PG110.

Custom Alert Examples

 

SQL Server

 

  1. Concurrent Sessions - Counts the number of user sessions currently connected to the SQL instance and alerts the "DBAs" when that exceeds 100.
  2. Locking - determines if locking problems, i.e. waits on LCK% wait types have occurred.
  3. Space Monitor - reviews space on each disk that contains a SQL Server datafile and alerts based on free space amounts.
  4. Job Failure - determines if a SQL Server job step has failed recently.
  5. CPU Utilization - calculates and laerts on the CPU Utilization over a defined timeframe.

 

Oracle

  1. Shared Pool Size - Calculates the current size of the Oracle shared pool and sends an alert to "All DBAs" if it is larger than 70 MB.
  2. Library Cache Miss Ratio - Executes once per hour and calculates the Oracle library cache miss ratio. If this value is above 2%, which is less than a 98% hit ratio, an alert will be sent to the "On Call" group of DBAs.
  3. Concurrent Sessions - Counts the number of user sessions currently connected to the database and alerts the "DBAs" when that exceeds 100.
  4. Shared Pool Request Failure - Will send an alert anytime a request failure is identified in the Oracle shared pool. If the number of request failures is between one and five, the alert will be sent to "All DBAs" group, and sent to the "On Call" group anytime the value is above six.
  5. Login Failures - If your Oracle database is configured for auditing, this alert will monitor for logon failures and alert the DBA group. It runs once every hour and looks for logon failures from the last hour.
  6. Extent Alert - This alert provides notification when the maximum chunk of free space within a dictionary managed tablespace is smaller than 2 * next_extent size of any object it contains.
  7. Execution Plan Change - provides a list of SQL statements that experienced an execution plan change within the last hour.