SQLServer Profiler Impact: GUI vs Server-side
After a recent talk at Cambridge NxtGenUG I was asked what the effect on SQLServer performance of gathering a trace in batch mode as opposed to using the GUI. The obvious answer, as always with these things, is “it depends”. But I was intrigued to see if I could quantify that a little further. The [...]