Lesson 2: Using Database Engine Tuning Advisor


Applies To: SQL Server 2016

Database Engine Tuning Advisor enables you to tune databases, manage tuning sessions, and view tuning recommendations. Users with advanced knowledge of physical design structures can use this tool to perform exploratory database tuning analysis. Database tuning novices can also use the tool to find the best configuration of physical design structures for the workloads they tune. This lesson provides basic practice for database administrators who are new to the Database Engine Tuning Advisor graphical user interface and for system administrators who may not have extensive knowledge of physical design structures.

It contains the following topics:

  • Tuning a Workload

  • Viewing Tuning Recommendations

  • Viewing Tuning Reports

Tuning a Workload

Community Additions