Responding to ADDM Performance Findings - wykład

Responding to ADDM Performance Findings
You can act upon the recommendations that accompany ADDM performance findings.
To respond to ADDM performance findings:
1. 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 appearsThe performance findings for the ADDM task and the performance impact of each
finding (%) are listed in the Findings table.
2. 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.
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.
3. 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.
... zobacz całą notatkę