Post reply

SQL Profiler

  • January 5, 2005 at 3:49 pm

    #162975

    I am trying to use the SQL Profiler with the default template.  It does not matter what Database Name Like <dB name> Filter I choose, when I run the Profiler it just spits out all activity on all databases on the server I chose to run Profiler on.   It also does not show what database name each trace row is recording.  What is the trick to filter the Database Name?  Is it possible to only trace one database name?  Why am I getting activity traced from all the other databases on this SQL 2000 Server running on Windows 2003 Server?

  • January 5, 2005 at 4:23 pm

    #536095

    Try filtering on databaseID.  You can find it out with the sp_helpdb <database name> command, the dbid column.  That works better for me.

    Kathi 

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • January 6, 2005 at 3:30 am

    #536132

    I once read that this is due to a bug in Sql2k - something to do with the order in which filters are processed.  I always have this problem and usually use the Group facility instead (in the 'Data Columns' tab, move DatabaseName to the top of the list so it falls under 'Groups').  It's not ideal, but does the job if you are just running the trace for a short period of time.

    It will still return everything, but at least all the traces for the database you are interested in will still be together.

    Hope that helps,

    Martin

  • January 6, 2005 at 5:31 am

    #536144

    Hi, have had similar problems and used the option where database name 'not like' as opposed to 'like' and listed all the others.  Depends how many you have I guess...long winded but worked.

  • January 6, 2005 at 7:13 am

    #536172

    As KAthi said, I would use the DBID instead.


    Shamless self promotion - read my blog http://sirsql.net

  • January 6, 2005 at 10:32 am

    #536246

    for some reason, the like database name filter has never worked for me.  yeah, the advice given of using the database ID works well.  look in sysdatabases in the master database to find the ID of the right database.  Good luck.

  • January 6, 2005 at 12:42 pm

    #536269

    see if you can put your requirements in the text field. I used to have a similar situation, but even limiting to dbid and objectid( that what i also had) didnt do the trick. Only text did.

Viewing 7 posts - 1 through 6 (of 6 total)

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