Sql Server Database Engine Tuning Advisor

The users who like to watch over their database and query performances Database Engine Tunig Advisor (dta) can be helpful. It can be used to compare your sql queries  too.

This msdn tutorial will teach you how to navigate the Database Engine Tuning Advisor GUI, and how to perform some basic tasks with both the GUI and the dta utility. It contains the following lessons:

Lesson 1: Basic Navigation in Database Engine Tuning Advisor

In this lesson, you will familiarize yourself with the new Database Engine Tuning Advisor GUI and learn how to set display options and layout.

Lesson 2: Using Database Engine Tuning Advisor

In this lesson, you will learn how to perform basic tuning tasks with the Database Engine Tuning Advisor GUI.

Lesson 3: Using the dta Command Prompt Utility

In this lesson, you learn how to start the dta command prompt utility and how to run some simple tuning commands.