• MysteryJimbo (10/21/2010)


    GilaMonster (10/20/2010)


    MysteryJimbo (10/20/2010)


    I believe its a combination of myth and/or poorly configured traces that have spread this across a multitude of articles.

    I have personally brought down a busy production server with a lightweight trace via the profiler GUI. It's no myth.

    I'm not denying it isnt possible to bring down a server. Just its not impossible to use profiler if you are careful. We have two profiler traces and a server side trace running on a busy website server with between 5000 and 20000 concurrent and running connections. The database itself performs at least 40 million transactions/queries per day. So it is possible to successfullly use profiler on a prod db server so long as you are selective.

    I've had similar positive experiences on very busy servers by implementing traces prudently. I have never locked up a server by using Profiler and executing traces if the server wasn't already overloaded.

    LC