Configure a DPA alert

SolarWinds DPA alerts give you proactive control of your databases, notifying you of issues before they become problems for end users. Set thresholds on key wait time statistics, resource metrics, or standard administration indicators. The result is improved customer service, fewer help desk tickets, and increased compliance with database service-level agreements.

DPA includes the following types of alerts:

  • Wait Time alerts are based on the amount of time users or applications waited on the database. They are triggered when wait time exceeds a user-defined threshold, or when wait time is much higher than normal (an anomaly).
  • Resources alerts are triggered when a resource metric, such as CPU utilization or memory usage, exceeds its threshold.
  • Administrative alerts are used to monitor the health of the database system. For example, you can configure an alert that is triggered when the database instance is not accessible or when any database parameter changes.
  • Custom alerts are user-specified queries that are run against the monitored database or the DPA repository. The query returns a value (or set of values) that might trigger an alert depending on user-defined threshold settings.

Configure a Wait Time alert

  1. Click Alerts, and then click the Manager Alerts tab.
  2. Select Wait Time as the Alert Category.

  3. Select the type of alert.

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

  4. Click Create Alert.
  5. In the Alert Information section, enter a unique name and select the execution interval.

    The execution interval specifies how often the alert runs and also the amount of data that DPA examines. For example, if the execution interval is 10 minutes, DPA executes the alert every 10 minutes and queries the last 10 minutes of data to determine whether to trigger the alert.

    SolarWinds recommends an execution interval of at least 10 minutes. This allows time for valid samples and prevents unnecessary alerts from a single slow execution.

    Alerts are active by default. Clear the Active check box to disable an alert but not delete it.

  6. Enter the text to be sent with the email or page notification. You can include an explanation of the alert and the suggested resolution.

  7. Select the database instances that the alert applies to.
  8. If Alert Parameters are required for the type of alert you are configuring (for example, the SQL hash or wait type), click Search, enter a search string, and select the parameter.
  9. For all Wait Time alerts except Database Instance Wait Time Anomaly, specify the thresholds for each alert level you want to enable.

    Leave the max value for the highest level blank to alert on anything above the minimum value for that level. If you configure multiple levels, the Max value for lower levels must equal the Min value for the next higher level.

    Alert thresholds for anomalies have default values, which can be changed through advanced configuration options.

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

    • 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 this alert is triggered.

  11. Verify or change the notification policy.
  12. Click Test Alert and verify that the recipients receive the email.
  13. Click Save.

Configure a Resources alert

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).

  1. If necessary, view or change the Warning and Critical thresholds for the resource metrics that you want to alert on.

    For Resources alerts, the thresholds are specified in the resource settings instead of in the alert configuration.

  2. Click Alerts, and then click the Manager Alerts tab.
  3. Select Resources as the Alert Category.

  4. Select the type of alert.

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

  5. Click Create Alert.
  6. In the Alert Information section, enter a unique name and select the execution interval.

    The execution interval specifies how often the alert runs and also the amount of data that DPA examines. For example, if the execution interval is 10 minutes, DPA executes the alert every 10 minutes and queries the last 10 minutes of data to determine whether to trigger the alert.

    SolarWinds recommends an execution interval of at least 10 minutes. This allows time for valid samples and prevents unnecessary alerts.

    Alerts are active by default. Clear the Active check box to disable an alert but not delete it.

  7. Enter the text to be sent with the email or page notification. You can include an explanation of the alert and the suggested resolution.

  8. Select the database instances that the alert applies to.
  9. Specify the following Alert Parameters:
    1. For alerts against all metrics in a category, select the category.

      For alerts against a single resource metric, you can select a category to filter the Resource list.

    2. For alerts against a single resource metric, select the resource.
    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. For 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.

      CalculationDescription
      % meeting metric alarm criteria

      DPA assigns an alert level when a certain percentage of the values collected during an interval meet or exceed the threshold for that level. Use the Percentage drop-down to specify the percentage.

      For example, if the Percentage is 75% and 8 of 10 metric values are at or above the critical threshold, DPA assigns an alert level of Critical for the interval.

      AverageDPA uses the average of the values collected during an interval to assign the alert level for that interval.
      MedianDPA uses the median value collected during an interval to assign the alert level for that interval.
      MaximumDPA 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.

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

    • 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 this alert is triggered.

  11. Verify or change the notification policy.
  12. Click Test Alert and verify that the recipients receive the email.
  13. Click Save.

Configure an Administrative alert

  1. Click Alerts, and then click the Manager Alerts tab.
  2. Select Administrative as the Alert Category.

  3. Select the type of alert.

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

  4. Click Create Alert.
  5. In the Alert Information section, enter a unique name, select the execution interval, and enter the email notification text.

    SolarWinds recommends an execution interval of at least 10 minutes.

  6. Select the database instances that the alert applies to.
  7. Enter the Alert Parameters, if any.
  8. Specify the thresholds for each alert level you want to enable. (Some Administrative alerts have only one level.)

    Leave the max value for the highest level blank to alert on anything above the minimum value for that level. If you configure multiple levels, the Max value for lower levels must equal the Min value for the next higher level.

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

    • 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 this alert is triggered.

  10. Click Test Alert and verify that the recipients receive the email.
  11. Click Save.

Configure a Custom alert

Use Custom alerts to execute SQL statements or stored procedures against the monitored database or DPA repository to check for conditions not covered by other DPA alerts. Any parameter that can be returned to DPA using a SQL statement or stored procedure can be used as the basis for a custom alert.

The SQL statements or stored procedures in a custom alert must return one of the following types of values:

Value returned Description
Single numeric value The SQL statement or stored procedure returns a single numeric value. The alert is triggered if the value exceeds the defined High, Medium, Low, and Info thresholds.
One or more name/numeric value pairs (SQL statements only)

The SQL statement returns one or more rows of data. Each row contains a string in the first column and a numeric value in the second column. For example, the query could return database names and the amount of free space for each one:

DB1   120
DB2   840
DB2    35

Single Boolean value The SQL statement or stored procedure returns a string value of TRUE or FALSE. The alert is triggered if TRUE is returned.
Single alert status The SQL statement or stored procedure returns a string value that specifies the alert status. Valid values are NORMAL, INFO, LOW, MEDIUM, and HIGH.
  1. Click Alerts, and then click the Manager Alerts tab.
  2. Select Custom as the Alert Category.

  3. Select the type of alert.

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

  4. Click Create Alert.
  5. In the Alert Information section, enter a unique name, select the execution interval, and enter the email notification text.

    SolarWinds recommends an execution interval of at least 10 minutes.

  6. To run the SQL statement or stored procedure against a monitored instance (instead of the DPA repository), select the database instances.

  7. Under Alert Parameters, enter the SQL statement or stored procedure to execute.
  8. In the Execute Against drop-down, indicate if the SQL statement or stored procedure should be executed against the selected monitored database instances or against the DPA repository database.
  9. If the alert returns a numeric value, specify the thresholds for each alert level you want to enable.

    Leave the max value for the highest level blank to alert on anything above the minimum value for that level. If you configure multiple levels, the Max value for lower levels must equal the Min value for the next higher level.

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

    • 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 this alert is triggered.
  11. Click Test Alert and verify that the recipients receive the email.
  12. Click Save.