I recently used a free sql profiler product from Anjlab that was great and allowed me to sort the trace results even while the trace is running. The next time I tried to do this in the Sql Profiler that actually comes with Sql Server I didn't see a way to sort the trace results. Am I missing something or does the profiler that comes with Sql Server just really not let you do that?
You can when the trace is stopped go to File -> Properties -> Events Selection -> Organise Columns
and set up "Grouping" by the desired sort column(s) and then select "Grouped View" rather than "Aggregated View" in the short cut menu to get the results displayed sorted.
Doesn't look as though the grouping columns are alterable in a running trace however as the buttons are greyed out.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With