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.
Download Database Engine Tuning Advisor (DTA) in SQL Server 2005
