Filtering tip for SQL Server Profiler

The SQL server profiler is a great tool for tracing and debugging database transactions, stored procedure execution etc. To trace the goings on inside a stored procedure it’s always best to use the TSQL_SPs template as this will provide much more detail than the standard template.

Depending on the amount database activity, separating the wheat from the chaff to identify the event data your after could take longer than actually debugging the data. With this in mind it’s always best to set filters up front to minimize your search time.

From the trace properties dialog select the events selection tab, and then the column filters. From here you can narrow down your results based on the criteria you provide. For example if you are running a test database on the  same server as a production database, modify the DatabaseName like filter to the name of the test database.

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • Facebook
  • Twitter
  • Google Bookmarks

Leave a Reply

Your email address will not be published. Required fields are marked *