Using the Database Engine Tuning

The Database Engine Tuning Advisor, available with SQL Server 2005, has replaced the Index Tuning Wizard that was available in earlier versions of SQL Server. It can analyze trace activity captured through SQL Server Profiler or a T-SQL work load script against your database and recommend various performance tuning enhancements. These performance tuning enhancements can include creating and dropping indexes, or implementing indexed views or a partitioning strategy if you have the correct edition of SQL Server 2005.

The Database Engine Tuning Advisor can now recommend a number of performance enhancements across a number of databases simultaneously from a single trace or workload file. Although you can limit the amount ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.