Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Object Filter in SQL Profiler

Author  Topic 

buzzi
Starting Member

48 Posts

Posted - 2008-10-14 : 15:01:44
Hi All,
I am having trouble to eliminate a particular sp from the profiler trace, because this sp runs every few seconds and, if i start my trace it records 1000's of records in no time.

Here is what i am doing
1.Start profiler
2.Selectnew trace
3.check show all columns
4.click on column filters and then select objectname filter and then enter the sp name in the "Not Like" option.

by this i was expecting to see the trace with out the sp that i mentioned in the filter. But this is not working.

Any idea's?

thanks for the help

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-14 : 15:13:18
What events are you tracing?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

buzzi
Starting Member

48 Posts

Posted - 2008-10-14 : 15:22:27
Thanks Tara,

I am tracing

StoredProcedures
RPC:completed
T-SQL
SQL:BatchCompleted
SQL:BatchStarting

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-14 : 16:06:39
It is working fine for me for those events. Can you show us an example of the stored procedure name? Does it have an underscore in it (you may need to escape this)?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -