SQL Server Profiler: ignoring Report Server by default

SSRS is notorious (at least to me) for being very chatty with its SQL Server (Database Engine) data sources.  When I want to do some SQL profiling, I inevitably want to ignore anything coming from the report server so I can just look at what my app (or linqpad, or whatever) is doing.

Historically this has meant firing up Profiler, starting a trace, then going into the filters and adding Report Server to the list of applications to ignore.

Today when I did that, I figured there must be a way of making that the default, and sure enough there is:

First, choose Edit Template:

image

You shouldn’t need to change anything on the resulting page, it should default to SQL 2008 and “Standard” – yours is likely to say “Standard (default)” since it’s your default.  Mine says “Standard (user, default)” since I’ve made this change already:

image

Now choose the Events Selection tab:

image

Now click on Column Filters (just like you would in creating a new trace to modify its properties)

image

Then for Application Name, add “Report Server” (without quotes) to the “Not like” collection (again, same as if you were creating a new trace)

image

Click OK to dismiss that dialog and then Save to dismiss its parent, and you’re all set!

Next time to create a new trace, you’ll notice it already has Report Server filtered out!

image

Advertisements