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 Events Selection tab of the Trace File Template Properties dialog box to view the column properties of the trace or remove data columns from the trace.
To view this window, open a trace file. Then, on the File menu, click Properties, and then click the Events Selection tab.
View traced events which are organized by event category. Initially, all events in the trace are selected. Events can be selected by checking the box or by checking a data column for an event. If the event box is checked, all data columns available for that event are selected. If the data column for an event is checked, the event is checked and any other required column is also automatically checked. If you are viewing a trace file or table, clearing check boxes for events or data columns reduces the amount of visible data in the trace window for easier analysis. You can also change column filters to reduce the amount of visible data in the trace window. For more information about event classes, see SQL Server Event Class Reference.
View traced data columns. All relevant data columns in the trace are checked by default for each event included in the trace.
Specify filters by clicking the data column heading and entering the filter criteria. Filtered data columns are indicated by a filter icon to the left of the column label in the Edit Filter dialog box.
Show all events
Show all available events. By default, only rows in the Events Selection grid that are selected display. Uncheck this box to hide all unselected events in the Events Selection grid. If Show all events is checked and you are viewing a trace file or table, all events that were recorded in the trace display in the trace window.
Show all columns
Show all available data columns. By default, only data columns that are selected display. Uncheck this box to hide all unselected data columns in the Events Selection grid.
Launches the Edit Filter dialog box, which displays a filter icon to the left of the column label for filtered data columns. Use the Edit Filter dialog box to edit data column filters.
After selecting Events and data columns to trace, click Organize Columns to force the grid to reorder the column in the trace results window.