GilaMonster (10/19/2010)
You don't ever want to use Profiler gui against a production server. Use a server-side trace and trace to a fast local drive instead.
FWIW I've found lightweight traces are fine on high volume database environments. I believe its a combination of myth and/or poorly configured traces that have spread this across a multitude of articles.