O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

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 ...

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