SQL Index Tuning Wizard – Create a Profiler trace file for

Run trace for one database at a time. 

The events and data columns used by the Index Tuning Wizard are 
    SQL:BatchCompleted and the
    RPC:Completed events in the TSQL category, and the
    EventClass and Text data columns.

Save as trace file or table. NOTE: ITW won't run on a read-only database.

Comments are closed.

Post Navigation