Post reply

Profiler -- How to filter by database?

  • December 15, 2005 at 2:04 pm

    #188677

    Tried using the Profiler under SQL 2005 for the first time today.

    Perhaps I'm missing something, but I don't see any way to filter by "DatabaseID" now. 

    Was this a deliberate change? 

    I had been using the "DatabaseID" filter in SQL 2000 -- in our environments we have a dozen or more databases on each instance...

    - john 

  • December 16, 2005 at 3:15 am

    #609993

    Hi

      In trace Properties Select "Show all Coumns" Check Box, DataBaseId and DataBaseName are  column no 15 and 16.

     

    Regards

    Shrikant    

     

    Regards
    Shrikant Kulkarni

  • December 16, 2005 at 9:43 am

    #610101

    Shrikant,

    Thanks!  Knew it had to be there somewhere...

    - john

  • July 19, 2006 at 2:29 pm

    #650245

    Sorry for the dumb question but how do I get to the profiler for 2005??? It's driving me nuts.

     

  • July 19, 2006 at 4:27 pm

    #650268

    To Go to Profiler:

    Go to Start -> Programs -> Microsoft SQL Server 2005 -> Performance Tools

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

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