Sql Server Profile is not filtering

29 Nov 2005 9:32 PM

aletita

Hi Everybody, I'm new with Sql Profiler tool and I'm trying to trace a Stored
Procedure to run the Index Tuning Wizard for it. The problem is that I used
the SqlProfilerTuning template and I put filters like: DB name like mydb,
ObjectName like GetMyItems but I still get the execution of every procedure
of every DB.

My question is: why does my filters doesn't work correctly. Do I have to add
' ' or % to the string name? How can I also indicate that the object is a
Stored Procedure? How can I also exclude the sql agent procedures from the
tracing. I really need a very specific trace file.

Thanks for your help

29 Nov 2005 9:43 PM

Andrew J. Kelly

I always use a % when using LIKE. But dbname is usually not populated. Try
using DBID instead.

--
Andrew J. Kelly SQL MVP

Show quote

"aletita" <u16221@uwe> wrote in message news:581a69402d82d@uwe...
> Hi Everybody, I'm new with Sql Profiler tool and I'm trying to trace a
> Stored
> Procedure to run the Index Tuning Wizard for it. The problem is that I
> used
> the SqlProfilerTuning template and I put filters like: DB name like mydb,
> ObjectName like GetMyItems but I still get the execution of every
> procedure
> of every DB.
>
> My question is: why does my filters doesn't work correctly. Do I have to
> add
> ' ' or % to the string name? How can I also indicate that the object is a
> Stored Procedure? How can I also exclude the sql agent procedures from the
> tracing. I really need a very specific trace file.
>
> Thanks for your help