Stairway to Server-side Tracing - Step 9: Profiler versus Server-Side tracing

  • Dan Guzman

    Default port

    Points: 1468

    Comments posted to this topic are about the item Stairway to Server-side Tracing - Step 9: Profiler versus Server-Side tracing

  • Steve Eckhart

    SSCommitted

    Points: 1880

    I'm looking forward to reading this once it is completed. I hope Steve will highlight it when it's actually available.


    Steve Eckhart

  • rw_ebox

    SSChasing Mays

    Points: 630

    It is a good article. I always run profiler or sqldiag locally because of permance concern.

  • James_UK_Dev

    SSC Veteran

    Points: 211

    As well as the performance is that fact that when a 3rd party or the customer themselves is running the trace this can go wrong.

    Often we'll get a trace back without all the events we're interested in.

    For example it won't include the SQL run by triggers.

    Server-side tracing might be a way to ensure the correct events are run by providing the scripts ourselves.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply