Tutorial: Database Engine Tuning Advisor
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Welcome to the Database Engine Tuning Advisor tutorial. Database Engine Tuning Advisor examines how queries are processed in the databases you specify, and then recommends how you can improve query processing performance by modifying database structures such as indexes, indexed views, and partitioning.
Database Engine Tuning Advisor provides two user interfaces: a graphical user interface (GUI) and the dta command prompt utility. The GUI makes it easy to quickly view the results of tuning sessions, and the dta utility makes it easy to incorporate Database Engine Tuning Advisor functionality into scripts for automated tuning. In addition, Database Engine Tuning Advisor can take XML input, which offers more control over the tuning process.
This tutorial is intended for database administrators who are not familiar with the Database Engine Tuning Advisor GUI or the dta command prompt utility, but who are experienced with database concepts and structures, such as indexes and indexed views.
You must install SQL Server 2016 (or a later version) with the AdventureWorks2012 sample database. To enhance security, the sample databases are not installed by default. To install the sample databases, see Installing SQL Server Samples and Sample Databases.
After you finish the lessons in this tutorial, refer to the following topics for more information about Database Engine Tuning Advisor: