Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Sort Sql Profiler results

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?

like image 473
Brandon Moore Avatar asked Dec 26 '11 23:12

Brandon Moore


1 Answers

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.

like image 184
Martin Smith Avatar answered Oct 25 '22 05:10

Martin Smith