Tuning Queries Using the Database Engine Tuning Advisor
Creating the right indexes for a database project is not an easy job. To do this, a lot of factors must be considered:
The data model of the database
The amount and distribution of the data within the tables
Which queries are performed against the database
How often the queries occur
How often the data is updated
To help in designing indexes, SQL Server offers a tool called the Database Engine Tuning Advisor. The Database Engine Tuning Advisor requires a workload file, which can be a text file with the statements to be optimized, or a trace file, which can be produced with SQL Server Profiler. The Database Engine Tuning Advisor then optimizes the database using the SQL Server Query Optimizer ...
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step 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.