[dba-SQLServer] Trace kills performance?

Arthur Fuller fuller.artful at gmail.com
Thu Jul 10 08:10:10 CDT 2008


I was running a relatively simple trace using the locking issues template
and I can't believe how much it killed the server performance. I'm new to
tracing so maybe this is just how things are. I'm going to do another one
soon, and narrow the focus just to deadlocks. Hopefully that won't cripple
performance.

Anyone got some insights about this?

TIA,
Arthur



More information about the dba-SQLServer mailing list