Database Engine Tuning Advisor (Apply Recommendations)

After a workload has been analyzed and recommendations have been presented, on the Actions menu, click Apply Recommendations to open the Apply Recommendations dialog box.

Options

  • Apply now
    Generate a script for the recommendations, and runs the script to implement the recommendations.

  • Schedule for later
    Generate a script for the recommendations, and save the actions as a SQL Server Agent job.

  • Date
    Specify the date you want to run the SQL Server Agent job to apply the recommendations.

  • Time
    Specify the time you want to run the SQL Server Agent job to apply the recommendations.