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.

See Also: