Tuesday, March 12, 2013

Tuning SQL Server Profiler

This touches on a way to constain SQL Server Profiler to only crawl one database at the server you connect to. Here is how:

  1. Type "SQL Profiler" at the start menu to bring up SQL Server Profiler.
  2. Pick "New Trace..." from the "File" menu. You will be prompted to make a connection to your database. Do so.
  3. At the "General" tab at the "Trace Properties" dialog box set the "Use the template:" dropdown to "Tuning."
  4. Go to the "Event Selection" tab and click the "Column Filters..." button at the lower right.
  5. Click on "DatabaseName" at the "Edit Filter" dialog box which appears.
  6. Expand "Like" and type in the name of your database in the spot for entering a Like filter which appears.
  7. Click the "OK" button in the "Edit Filter" dialog box and then the "Run" button in the "Trace Properties" dialog box.

No comments:

Post a Comment