Database Engine Tuning Advisor (DTA) in SQL Server 2005

Peter Kitson

ISBN : -

Order a printed copy of this book from Amazon --UNAVAILABLE--


Cover Design - Database Engine Tuning Advisor (DTA) in SQL Server 2005
  

For your free electronic copy of this book please verify the numbers below. 

(We need to do this to make sure you're a person and not a malicious script)

Numbers

 



Sample Chapter From Database Engine Tuning Advisor (DTA) in SQL Server 2005
     Copyright © Sanjay Agrawal, Surajit Chaudhuri, Raja Duddupudi, Lubor Kollar, Arun Marathe, Vivek Narasayya, Manoj Syamala



Summary: 

Database administrators in enterprises today face the challenging task of determining an appropriate physical design that consists of partitioned tables, indexes, and indexed views and that both optimizes server performance and is easy to manage. Database Engine Tuning Advisor (DTA) in Microsoft SQL Server 2005 can assist in this task. Given a workload of SQL queries and updates, DTA recommends an appropriate physical design, and generates a script to implement the recommended physical design. For more advanced database administrators, DTA exposes a powerful mechanism to perform efficient exploratory what-if analysis of different physical design alternatives. DTA can be used against both SQL Server 2005 and SQL Server 2000.