Creating SQL Plan Baselines

Creating SQL plan baselines enables the optimizer to avoid performance regressions by using execution plans with known performance characteristics. If a performance regression occurs due to plan changes, a SQL plan baseline can be created and used to prevent the optimizer from picking a new, regressed execution plan.

To create SQL plan baselines:

1. On the SQL Performance Analyzer Task Result page, under Recommendations, click Create SQL Plan Baselines.

   The Create SQL Plan Baselines page appears. The Regressed SQL Statements section lists the regressed SQL statements that will be associated with the new SQL plan baselines.

2. Under Job Parameters, specify the parameters for the job:

   1. In the Job Name field, enter a name for the job.

   2. In the Description field, optionally enter a description for the job.

3. 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.

4. Click OK.

   The SQL Performance Analyzer Task Result page appears. A message is displayed to inform you that the job has been submitted successfully.