When I visit clients for the first time and conduct a performance review I introduce them to ClearTrace. It’s still the best way I know to identify exactly which queries are consuming the most resources. The downside is that it needs to be downloaded and create a database to store the results. I finally decided it would be easier if I could just upload a trace immediately.
This is a companion discussion topic for the original entry at http://billg.sqlteam.com/2011/01/07/an-online-version-of-cleartrace/