Running SQL Tuning Advisor

The SQL Tuning Advisor performs an in-depth analysis of regressed SQL statements and attempts to fix the root cause of the problem.

To run SQL Tuning Advisor:

1. On the SQL Performance Analyzer Task Result page, under Recommendations, click Run SQL Tuning Advisor.

   The Schedule SQL Tuning Task page appears.

2. In the Tuning Task Name field, enter a name for the SQL tuning task.

3. In the Tuning Task Description field, optionally enter a name for the SQL tuning task.

4. Under Schedule, select:

   • Immediately to start the job now.

   • Later to schedule the job to start at a time specified using the Time Zone, Date, and Time fields.

5. Click OK.

   The SQL Performance Analyzer Task Result page appears. A link to the SQL tuning report appears under Recommendations.

6. To view the SQL tuning report, click the SQL Tune Report link.

   The SQL Tuning Results page appears.