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.
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?
The error is obevious... did you store the profiler to a file or table/ was there any activities going on the server Madhu
