This touches on a way to constain SQL Server Profiler to only crawl one database at the server you connect to. Here is how:
- Type "SQL Profiler" at the start menu to bring up SQL Server Profiler.
- Pick "New Trace..." from the "File" menu. You will be prompted to make a connection to your database. Do so.
- At the "General" tab at the "Trace Properties" dialog box set the "Use the template:" dropdown to "Tuning."
- Go to the "Event Selection" tab and click the "Column Filters..." button at the lower right.
- Click on "DatabaseName" at the "Edit Filter" dialog box which appears.
- Expand "Like" and type in the name of your database in the spot for entering a Like filter which appears.
- 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