Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Database Performance Analyzer (DPA) > DPA Documentation > 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

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.


  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.


    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.


  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