Responding to ADDM Performance Findings

You can act upon the recommendations that accompany ADDM performance findings.

To respond to ADDM performance findings:

In the ADDM Tasks table on the ADDM tab of the Performance Hub page, click the link in the Task Name column to view the performance findings for that task.

The Automatic Database Diagnostic Monitor (ADDM) page appears.

Description of the illustration perf_hub_paddm_perf.gif

The performance findings for the ADDM task and the performance impact of each finding (%) are listed in the Findings table.
Click the link in the Finding column for a particular finding to view the finding and recommendations (if any) associated with it.

The Performance Finding Details page appears.

Description of the illustration perf_paddm_findings_det.gif

The performance findings table lists the performance findings for the ADDM task. For each finding, the table shows the finding category, recommended action, rationale for the recommendations, and the expected benefit of implementing the recommendation.

When you select a finding that has a recommendation that you can implement using ADDM, the Implement button becomes available for that finding.
For a finding that has a recommendation that you want to implement using ADDM, select the finding and click Implement.

For this example, the Schedule SQL Tuning Advisor page appears, on which you are prompted for the information necessary to run the SQL Tuning Advisor on the selected SQL statement.