SQL Server Profiler - Organize Columns
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Use the Organize Columns dialog box to select data columns for grouping or aggregating events that are displayed in a trace, which makes large trace files or tables easier to view and analyze.
Aggregating moves and collapses all events in the trace under its respective event class type. A plus sign (+) appears to the left of the event class name. Clicking the plus sign expands the event class so you can view all events of that type.
Grouping organizes all event classes of a specific type together in the trace window display. However, the events are not collapsed under the event class type.
When you group or aggregate events in a trace window display, the columns selected for grouping or aggregating remain fixed in the display window, but you can scroll to the right or left to view all other data columns.
To access this dialog box, open an existing trace file or table, and click Properties on the SQL Server Profiler File menu. In the Trace Properties dialog box, click the Events Selection tab, and then click Organize Columns. You can also click Organize Columns on the Events Selection tab when you are creating a new trace.