Submit a ticketCall us

AnnouncementsSystem Monitoring for Dummies

Tired of monitoring failures disrupting the system, application, and service? Learn the key monitoring concepts needed to help you create sophisticated monitoring and alerting strategies that can help you save time and money. Read the eBook.

Get your free eBook.

Home > Success Center > Database Performance Analyzer (DPA) > DPA Documentation > Database Performance Analyzer Getting Started Guide > Create a report to track wait types for a single SQL statement

Create a report to track wait types for a single SQL statement

Table of contents
No headers
DPA_GS_Home.png

Use DPA reports to identify database trends and track the results of your performance tuning.

The following example creates a report to track wait types for a specific SQL statement. If you made changes to reduce a specific type of wait for a SQL statement, you can use this report to determine if your tuning efforts were effective.

  1. In the DPA menu bar, click Reports.
  2. Select the database instance and the report type.

    For this example, choose Top Waits for single SQL.

    File:Success_Center/New_Articles/DPA_Getting_Started_Guide/080/010/gs-reports-top-waits.png

  3. Click Search and locate the SQL statement.

    If you named the statement, enter part of the name and make sure Name and Hash is selected. Then click Search.

    The Search Results lists all SQL statements run against the selected database instance that match your criteria.

    File:Success_Center/New_Articles/DPA_Getting_Started_Guide/080/010/gs-reports-search.png

  4. Select the SQL statement, and click OK.
  5. Click Report Options.

    This report can show the top waits, or it can show specific wait types (regardless of their wait times).

  6. For this example, complete the following steps to specify db_file_scattered read waits and Memory/CPU waits.
    1. Under Waits to Display, select User-Defined Waits and click Add.

      File:Success_Center/New_Articles/DPA_Getting_Started_Guide/080/010/gs-reports-top-waits-add.png

    2. Enter part of the wait name (for example, scattered), and click Search.

      The Search Results section lists all waits that match your search criteria.

      File:Success_Center/New_Articles/DPA_Getting_Started_Guide/080/010/gs-reports-search-wait-types.png

    3. Select db file scattered read and click OK.
    4. Repeat steps to add Memory/CPU waits, and click OK.

      File:Success_Center/New_Articles/DPA_Getting_Started_Guide/080/010/gs-report-selected-wait-types.png

  7. Under Dates to Display, review the dates that the report should include.

    In this example, the date range is the current month, and the report includes only weekdays.

    The Data Range at the bottom of this section shows the time period for which data is available.

    File:Success_Center/New_Articles/DPA_Getting_Started_Guide/080/010/gs-report-date-range.png

  8. Under General, complete the following fields.

    Report Name Enter a unique name to identify this report in the report list.
    Report Title (Optional) Enter a title to display at the top of the report. If you leave this field blank, the report title defaults to the report type, database instance, and time period.
    Report Description (Optional) Enter a description to explain the report's content or purpose.

    File:Success_Center/New_Articles/DPA_Getting_Started_Guide/080/010/gs-reports-name-title.png

  9. In the New Report section at the top of the window, click Display Report.

    The report opens. In this example, the drop in wait times after September 7th shows that the tuning efforts were effective.

    File:Success_Center/New_Articles/DPA_Getting_Started_Guide/080/010/gs-report-display.png

  10. Click Save and then OK to save the report.
  11. To return to the list of reports, click Reports in the breadcrumb navigation at the top of the window.

    File:Success_Center/New_Articles/DPA_Getting_Started_Guide/080/010/gs-reports-breadcrumbs.png

You can view the report from the Reports tab at any time, or schedule the report to run automatically and be emailed to a group of recipients.

Last modified

Tags

Classifications

Public