---
title: "Lesson 2: Using Database Engine Tuning Advisor | Microsoft Docs"
ms.custom: ""
ms.date: "06/13/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology: performance
ms.topic: conceptual
helpviewer_keywords: 
  - "Database Engine [SQL Server], tutorials"
ms.assetid: 3317d4f8-ed9e-4f2e-b5f1-a6bf3a9d6c8d
author: stevestein
ms.author: sstein
manager: craigg
---
# Lesson 2: Using Database Engine Tuning Advisor
  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  
  
## Next Task in Lesson  
 [Tuning a Workload](lesson-1-1-tuning-a-workload.md)