"David Gugick" <davidg-nospam@imceda.com> schrieb im Newsbeitrag
news:uPhpIcG0EHA.2016@TK2MSFTNGP15.phx.gbl...
> OJ wrote:
> > I ran sql server profiler against database (SP:Completed,
> > SP:StmtStarting,SP:StmtCompleted, some Lock events, and
> > Errors and Warnings events).
> > When I run ITW against this trace, I get following error:
> >
> > "There are no events in the workload. Either the trace
> > file contained no SQL batch or RPC events or the SQL
> > script contained no SQL queries."
> >
> > Does anybody have an idea what's going on here?
> > Thanks,
> > OJ
>
> ITW requires SQL:BatchCompleted and/or RPC:Completed events because it
> works at the batch level and those two events are for batches. You can
> remove the other events.

> "David Gugick" <davidg-nospam@imceda.com> schrieb im Newsbeitrag
> news:uPhpIcG0EHA.2016@TK2MSFTNGP15.phx.gbl...
>> OJ wrote:
>>> I ran sql server profiler against database (SP:Completed,
>>> SP:StmtStarting,SP:StmtCompleted, some Lock events, and
>>> Errors and Warnings events).
>>> When I run ITW against this trace, I get following error:
>>>
>>> "There are no events in the workload. Either the trace
>>> file contained no SQL batch or RPC events or the SQL
>>> script contained no SQL queries."
>>>
>>> Does anybody have an idea what's going on here?
>>> Thanks,
>>> OJ
>>
>> ITW requires SQL:BatchCompleted and/or RPC:Completed events because
>> it works at the batch level and those two events are for batches.
>> You can remove the other events.
>
> Note also that there is a default template that records all events
> necessary for the wizard.
>
>    robert