Filter Profiler Trace To Display Events From A Specific Database

As a DBA or a database programmer, you may often need to run the profiler and trap the queries and statements either for error debugging or to find performance issues. Most of the time you may want to limit the tracing to a specific database. Here is the step by step instruction to filter the profiler trace to display events from a specific database.

Steps To Filter Profiler Trace For Events From A Database

  1. From the profiler trace window, go to menu Files > Properties.
  2. In the Trace Properties window, go to Events Selections tab.
  3. Select the check box Show all columns.
  4. Press the Columns Filters… button below.
  5. In the Filter pop-up window, from the left panel select DatabaseName.
  6. From the right panel, under Like tree node, enter the database name and press OK.
  7. Then, press Run button to start the trace.

Now the profiler trace window will capture only the events from the specified database.

Filter Profiler Trace To Display Events From A Specific Database

Related Articles

Related Articles & Tools

Leave your thoughts...

This site uses Akismet to reduce spam. Learn how your comment data is processed.