Performance Impact: Profiler Tracing vs. Server Side SQL Tracing

http://sqlblog.com/blogs/linchi_shea/archive/2007/08/01/trace-profiler-test.aspx