O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. Tuning with Database Engine Tuning Advisor

In this chapter we will cover:

  • Analyzing queries using Database Engine Tuning Advisor
  • Running Database Engine Tuning Advisor for Workload
  • Executing Database Tuning Advisor from command prompt

Introduction

Database Engine Tuning Advisor (DTA) suggests ways to tune the database by analyzing the Workload provided. DTA helps in creating an efficient index, an indexed view (if it's supported by the SQL Server Edition you are using), statistics, and partitions. DTA can give efficient suggestions only if you have created proper workload with sufficient data. For further details of creating workload, refer Creating a trace or workload recipe of Chapter 1, Mastering SQL Trace Using Profiler.

Studying an ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required