Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Database Performance Analyzer (DPA) > Database Performance Analyzer Getting Started Guide > Alerts > Create an alert to monitor SQL statement execution time

Create an alert to monitor SQL statement execution time

Table of contents
No headers
Created by Melanie Boyd, last modified by Melanie Boyd on Sep 29, 2016

Views: 262 Votes: 0 Revisions: 4
DPA_GS_Home.png

Use DPA alerts to send notifications about potential problems so that your team can take steps to resolve the issue before it affects end users.

A previous example showed how to use DPA to resolve performance problems that were caused by a long-running SQL statement. This example adds an alert to notify the DBA group if that SQL statement's average execution time is above a threshold during the alert execution interval. If this alert is triggered, the team can stop the query before end users notice a performance problem.

  1. On the DPA menu, click Alerts.
  2. Click the Manage Alerts tab.
  3. Select the alert category and the alert type.

    For this example, select Wait Time as the category and Average Wait Time for a Single SQL as the type.

    File:Success_Center/New_Articles/DPA_Getting_Started_Guide/070/030/gs-create-alert-category-type.png

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

    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.

  6. Select the database instance that the SQL statement runs against.

  7. Select the SQL statement the alert monitors.

    1. Click Search next to the SQL Hash field.

    2. Because this SQL statement has a name, leave Name and Hash selected as the SQL Search Type.

    3. Select the name of the SQL statement from the list.

      File:Success_Center/New_Articles/DPA_Getting_Started_Guide/070/030/gs-create-alert-sql-statement.png

    4. Click OK. The SQL statement's hash value is displayed in the SQL Hash field.
  8. Specify the thresholds for each alert level you want to enable.

    In this example, a High alert is triggered if the SQL statement's average wait time during an execution interval is 30 seconds or more.

    File:Success_Center/New_Articles/DPA_Getting_Started_Guide/070/030/gs-alert-levels.png

  9. Select the person or group who gets notified when an alert level is triggered and 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. See Create contacts and contact groups.

  10. Verify that the appropriate Notification Policy is selected.

  11. Click Test Alert and verify that the recipients receive the email.
  12. Click Save.
Last modified
17:09, 29 Sep 2016

Tags

Classifications

Public