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:
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:
Now choose the Events Selection tab:
Now click on Column Filters (just like you would in creating a new trace to modify its properties)
Then for Application Name, add “Report Server” (without quotes) to the “Not like” collection (again, same as if you were creating a new trace)
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!