SQL Server Performance

Index Tuning Wizard issues

Discussion in 'Performance Tuning for DBAs' started by sramesh, Mar 28, 2008.

  1. sramesh New Member

    Hi All,
    I got error while executing the Index tunning wizard.
    Error Message:
    There are no events in the workload. either the trace file contained no SQL batch or RPC events or the SQL scripts contained no SQl queries.
    I have captured SQL profiled using the template SQLProfilerTuning.



  2. Luis Martin Moderator

    Yes, that happens.
    The best method is: open the trace file with profiler, identify long queries (duration and/or Cpu), copy and paste into Query Analyzer and from there call ITW.
    A couple of things: If query have temp tables (#table) ITW don't work. If query is Store Procedure and this sp call another sp, ITW don't work.
    Are you follow the idea?
  3. madhuottapalam New Member

    The error is obevious... did you store the profiler to a file or table/ was there any activities going on the server
    Madhu

Share This Page