Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Azure SQL Managed Instance
You can group data columns in a trace by selecting Organize Columns in the trace table or Trace File Properties dialog box, or when you define a trace. Grouping the data columns enables you to better analyze SQL Server Profiler trace output. For more information, see View and Analyze Traces with SQL Server Profiler.
Organize Columns enables you to either group the trace events, or to group and aggregate them by the data columns you select.
Duration | StartTime | EventClass | ClientProcessID |
---|---|---|---|
12/12/2006 3:16:43 PM | SQL:StmtStarting | 2124 | |
0 | 12/12/2006 5:39:23 PM | Audit Login | 648 |
1 | 12/12/2006 5:24:44 PM | SQL:StmtStarting | 2124 |
25 | 12/12/2006 5:24:44 PM | SQL:StmtCompleted | 648 |
EventClass | StartTime | Duration | ClientProcessID |
---|---|---|---|
+ ExistingConnection (6) | |||
+ SQL:BatchStarting (25) | |||
+ SQL:StmtCompleted (11) | |||
+ SQL:SmtStarting (21) |
Open an existing trace file or table.
On the File menu, click Properties.
In the Trace File Properties or Trace Table Properties dialog box, click the Events Selection tab.
On the Events Selection tab, click Organize Columns.
In the Organize Columns dialog box, select the columns you want to display in a group, and click Up to move them under Groups. After you have moved all the columns you want to move under Groups, you can use the Up and Down buttons to rearrange their order.
Moving the data column names into the Groups list means that the displayed trace is first organized by the values in the top-most data column appearing in the Groups list, then by the second data column in the Groups list, and so on.
Click OK in the Organize Columns dialog box, and then click OK in the Trace Table Properties or Trace File Properties dialog box.
After clicking OK in the Trace Table Properties or the Trace File Properties dialog box, the data columns are reorganized in the displayed trace. The data column that you moved to the top-most position in the Groups list is located first in the trace display when you are reading the grid from left to right. The rows in the trace are organized in ascending order by the values contained in the data columns that you included in the Groups list. The columns chosen for grouping remain fixed in the display, but you can scroll right or left to view the other columns.
To ungroup the displayed trace data, click Grouped View on the View menu to cancel the selection. If you want to revert to the grouped view, click Grouped View on the View menu again to reselect it.
Open an existing trace file or table.
On the File menu, click Properties.
In the Trace File Properties or Trace Table Properties dialog box, click the Events Selection tab.
On the Events Selection tab, click Organize Columns.
In the Organize Columns dialog box, select one column by which you want to group and aggregate the displayed trace events. Click Up to move the column name under Groups. You can use the Up and Down buttons to rearrange the remaining columns under Columns if needed.
Click OK in the Organize Columns dialog box, and then click OK in the Trace Table Properties or Trace File Properties dialog box.
After clicking OK in the Trace Table Properties or the Trace File Properties dialog box, the data columns are reorganized in the displayed trace. All other data column events are aggregated under the data column that you moved into the Groups list. Click the plus sign (+) to the left of the event in the data column you chose for aggregation to expand it and view all events of that type. The column chosen for aggregation remains fixed in the display, but you can scroll right or left to view the other columns.
To revert to a normal view of the trace data, click Aggregated View on the View menu, which cancels the selection. If you want to revert to the aggregated view, click Aggregated View on the View menu again to reselect it. Note that you can also click Grouped View on the View menu to display the grouped trace events without collapsing them.
Create a Trace (SQL Server Profiler)
Open a Trace Table (SQL Server Profiler)
Open a Trace File (SQL Server Profiler)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today