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

Question

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

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

Steve Eckhart SSCommitted Points: 1880 More actions · Answer 1

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 SSC Eights! Points: 806 More actions · Answer 2

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

James_UK_Dev SSC Veteran Points: 241 More actions · Answer 3

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.