Documentation forDatabase Performance Analyzer

Configure a DPA Resources alert

Resources alerts are triggered when a resource metric, such as CPU utilization or memory usage, exceeds its threshold. A Resources alert can monitor a single resource metric (such as Buffer Cache Hit Ratio) or all metrics in a resource category (such as Memory).

For information about other DPA alert categories, see DPA alerts.

Verify resource thresholds

Thresholds for Resources alerts are specified in the resource settings, not within the alert. You can view or change them if needed.

Create or edit a Resources alert

  1. From the DPA main menu, click Alerts.
  2. Click the Manage Alerts tab.
  3. Do one of the following:
    • To create a new alert, select Resources as the Alert Category, select the Alert Type, and then click Create Alert.

      To find out more about each alert type, select it to display a description on the right.

    • To edit an existing alert, click the alert name.
  4. In the Alert Information section:

    1. Enter a unique name.

    2. If you want to disable the alert, clear the Active check box.
    3. Select the execution interval.

      The execution interval specifies how often the alert runs and the amount of data that DPA examines. For example, if the execution interval is 10 minutes, DPA executes the alert every 10 minutes and examines the last 10 minutes of data to determine whether to trigger the alert. DPA recommends an execution interval of at least 10 minutes to prevent unnecessary alerts from a temporary condition.

    4. Enter the notification text to be sent with the email notification. Include an explanation of the issue and the suggested resolution.

      If you apply a custom email template to this alert, the email notification includes the notification text if the email template contains one of the following variables:

      • Alert Notification text: [=alert.notificationText]
      • Results: [=dpa.body] (included by default)
  5. Select the database instances that the alert applies to.
  6. Under Alert Parameters:

    1. For alerts against all metrics in a category, select the Category.

      For alerts against a single resource metric, you can (optionally) select a Category to filter the Resource list.

    2. For alerts against a single resource metric, select resource metric from the Resource drop-down menu.

      The Resource drop-down menu lists only resource metrics with thresholds. You can set or change thresholds for any resource metric.

    3. Specify the Calculation that is used to determine the alert level for an execution interval.

      To determine the alert level, DPA looks at the values collected during an execution interval and applies the specified calculation.

      Example: For a single resource alert, if the metric value is collected once each minute and the execution interval is 10 minutes, DPA looks at the 10 values collected for an interval and applies one of the following calculations.

      Calculation Description
      % meeting metric alarm criteria

      The alert is triggered when a certain percentage of the values collected during an execution interval meet or exceed the warning or critical threshold for the metric or metrics. Use the Percentage drop-down to specify the percentage.

      Example: The alert is for a category that contains 10 metrics. DPA collects the metric values once each minute, and the alert is set to run once every 10 minutes. Therefore, during each interval, DPA collects 100 values. If the Percentage is 75%:

      • The alert is triggered at the warning level if 75 or more of these values exceed the warning threshold for the associated metric, but fewer than 75 exceed the critical threshold.
      • The alert is triggered at the critical level if 75 or more of these values exceed the critical threshold for the associated metric.
      Average DPA uses the average of the values collected during an interval to assign the alert level for that interval.
      Median DPA uses the median value collected during an interval to assign the alert level for that interval.
      Maximum DPA uses the maximum value collected during an interval to assign the alert level for that interval.
      Minimum

      DPA uses the minimum value collected during an interval to assign the alert level for that interval.

  7. Select the person or group who gets notified when each alert level is triggered and when the alert is broken. (The alert status is set to Broken if an error occurs during execution.)

    To send notifications when the alert returns to Normal, select a recipient for Normal.

    • If you have not added the person or group as a contact in DPA, click Add Contact or Add Contact Group and create the contact or group.
    • Select an SNMP contact to send SNMP traps when the alert is triggered. Select an SNMP contact for Normal to send a clearing notification when the alert status returns to Normal.
  8. Verify or change the notification policy.

    To send notifications when the alert returns to Normal, the notification policy must be Notify when level changes.

  9. Select the email template that defines the contents of the email notifications sent by this alert.
  10. Click Email Preview to see an example of the email that will be generated using the selected email template and contact information.

    If the alert applies to multiple database instances, select an instance in the Email Preview dialog box and click OK. After reviewing the email, you can select a different database instance or click Cancel to close the Email Preview dialog box.

    The email sent to users might not exactly match the preview because some alert parameters cannot be evaluated during a preview.

  11. Click Test Alert to test the alert and view the current alert level. The test does not generate an email.
  12. Click Save.