SQL Server 2005 Database Tuning Advisor -
01-21-2009
, 02:43 PM
I would like to use the SQL Server 2005 database tuning advisor for my one
of database on this database server for tuning indexes.
Should I create SQL Server profiler trace and use this in the database
tuning advisor for index analysis? Which template or options should be
selected for the profiler trace?
Please help me with the items that need to be completed for the database
tuning advisor for analyzing indexes?
Thanks, |