Post reply

How to filter blank test data output with query profiler

  • July 26, 2006 at 5:21 pm

    #61686

    I am having a hard time filtering out the results in query profiler that I need.  Basically I am trying to get results that only include the sql:stmtstarting text data for 'update hsi.plattertable'.  The dataset I get includes this information plus all of the stmts with blank text data.  The filters I am using are as follows

    databasename=testdb

    text data='update hsi.plattertable%'

    Any suggestions on how to get rid of these blank results would be great

    Thanks

  • July 31, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • July 31, 2006 at 3:16 pm

    #652476

    I've experienced this before when I've included events that do not return data for the column being filtered. The solution is to remove those events. What events are you capturing?

  • July 31, 2006 at 4:09 pm

    #652482

    Save your trace to a table and query the data.

    select *

    from <trace Table>

    where eventclass = 40

        and textdata like 'update hsi.plattertable%'

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • August 1, 2006 at 7:21 am

    #652581

    I created a SQL job that ran every one minute to delete from <trace Table> where textdata=''

    This took care of the issue and limited the size of the table, however it doesn't seem like this should be the only way to get around the situation.  I have heard that SQL2005 handles this much better.

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

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