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 > Reports > 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
Created by Melanie Boyd, last modified by Melanie Boyd on Sep 29, 2016

Views: 191 Votes: 0 Revisions: 4
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. Click Reports in the menu bar.
  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, specify the wait types that were targeted by the tuning efforts. These were db_file_scattered read waits and Memory/CPU waits.
    1. Under Waits to Display, select User-Defined Waits.

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

    2. Click Add.
    3. Enter part of the wait name and click Search.

      The Search Results 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

    4. Select db file scattered read and click OK.
    5. Repeat steps c and d 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 date range for which data is available.

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

  8. Under General, enter a unique name to identify this report in the report list. Optionally, enter and a title and description.

    The title is shown at the top of the report. By default, it is the report type, database instance, and time period.

    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, it 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 trail 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
17:16, 29 Sep 2016

Tags

Classifications

Public