| |
 |
|
SQL Server Tips by Robin Schumacher
|
Index/Database Tuning Wizard
The Index Tuning Wizard has its critics, yet it has its champions as
well. The concept is excellent: give SQL Server an SQL-based
workload or set of individual queries to work with, and let the SQL
Server reveal what object-based solutions may be of benefit in
improving performance.
Critics say the Index Tuning Wizard fails on many occasions to
recommend a proper indexing scheme or suggests indexes that are
ineffective. However, as has already been mentioned, tuning SQL and
a database’s physical design is an art form. Thus, it is never a bad
idea to get advice from as many sources as possible. Besides, just
like anything else, the Index Tuning Wizard has gotten better over
time, so it is worth a try.
In SQL Server 2005, the utility has been renamed the Database Tuning
Advisor and has been updated to include partitioning
recommendations.
The DBA can feed either utility a trace file created through
server-side tracing or SQL Profiler or a list of queries for SQL
Server to examine. Thus, the tool performs a thorough examination of
the database and SQL structures and presents recommendations.
Again, the Index/Database Tuning Wizard/Advisor is not perfect, but
can prove helpful in the right situations.
The above book excerpt is from:
High-Performance SQL Server DBA
Tuning & Optimization Secrets
ISBN:
0-9761573-6-5
Robin Schumacher
http://www.rampant-books.com/book_2005_2_sql_server_dba.htm |
