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.
Select the database instance and the report type.
For this example, choose Top Waits for single SQL.
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.
Click Report Options.
This report can show the top waits or it can show specific wait types (regardless of their wait times).
db_file_scattered readwaits and
Under Waits to Display, select User-Defined Waits.
Enter part of the wait name and click Search.
The Search Results lists all waits that match your search criteria.
db file scattered readand click OK.
Repeat steps c and d to add
Memory/CPU waits, and click OK.
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.
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.
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.
To return to the list of reports, click Reports in the breadcrumb trail at the top of the window.
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.