Using SQL Profiler on a database that's in production
I use SQL Profiler against production all the time.  When done correctly (filtering so that you get back a very small amount of data) against a server the risk is minimal.  Tracing everything down would be useless.