making it easier to find your app's SQL in the Profiler's output

This is a trick I’ve used in the past when the database I was running the profiler against had a lot going on and I just wanted to filter it based on a particular app.  This post describes it nicely!

SQL Profiler and “Application Name=MyApp;”

Here’s a great trick that can be really handy if you’re a fan of the SQL Profiler. In your application connection strings add the “Application Name” keyword/value.

Technorati Tags: