Specific Database Tuning

• b_boy

  Newbie

  Points: 0

  More actions

  November 24, 2007 at 11:42 am

  #181331

  Hello

  Anytime i use sql server profiler in 2005, it monitors my master and report server, and all i want to do is to monitor a particular db.

  what do i need to do?, do i need to put the "db%"?

• Gail Shaw

  Newbie

  Points: 0

  More actions

  November 25, 2007 at 12:11 pm

  #753822

  You can filter on the Database ID column and exclude the ids of databases that you don't want to see.

  Better to filter on ID than name, as not all events pass the DB name.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass