Post reply

SQL Profiler -- how to track the firing of a specific S.P.

  • December 31, 2007 at 10:48 am

    #763749

    make the proc name a filter in text

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • January 8, 2008 at 10:48 am

    #765817

    thanks for your response -- I have been playing around with the tool and your right using the filters is the way to remove items from the trace. It seems to require some trial and error thought to get the specific results desired.

    Thanks again for pointing me in the right direction

  • January 8, 2008 at 1:18 pm

    #765892

    I find not all filters quite work as you'd expect, and some give downright strange results - filtering by text seems to work usually and I use this if I want to profile against a particular table for instance.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply