SQL2005 profiler filtering

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Wood - 02 Jul 2008 21:08 GMT

Hi,

Is there a way to enter more than one condition when you create a filter in
a Profiler Template? I want to enter a number of different application names
in a missing stats template but I cannot see any way to do this using the
GUI.

Thanks

Chris

Reply to this Message

Linchi Shea - 02 Jul 2008 21:19 GMT

You should be able to add filtering conditions to a template just as you do a
profiler trace, and then save the template. I just tried it, and it worked as
expected. You can choose which template to edit by going to File -> Templates
-> Edit Template ..., Then, on the Events Selection tab, click on Column
Filters to add filters.

Linchi

> Hi,
>
[quoted text clipped - 6 lines]
>
> Chris

Reply to this Message

Chris Wood - 02 Jul 2008 22:17 GMT

Got it Thanks Linci. I had to double click on the Not Like to give me extra
filters I could add.

Thanks

Chris

> You should be able to add filtering conditions to a template just as you
> do a
[quoted text clipped - 19 lines]
>>
>> Chris

Reply to this Message

Linchi Shea - 02 Jul 2008 22:31 GMT

Or you can just type semi-colon (;) to go to the next line.

Linchi

> Got it Thanks Linci. I had to double click on the Not Like to give me extra
> filters I could add.
[quoted text clipped - 26 lines]
> >>
> >> Chris

Reply to this Message