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 Template Properties dialog box to view, edit, or specify event classes and data columns to include in a SQL Server Profiler trace template.
Specify events that should be traced by selecting or clearing the check box in the event column. Events are organized by event category.
If you selected Base new template on existing one on the General tab, events are automatically selected according to the specified template. For more information about event classes, see SQL Server Event Class Reference.
Specify data columns that should be traced by checking the box that corresponds with the event and the data column you need. All relevant event columns are checked by default for each event included in the trace, if the checkbox corresponding to the event is checked. If you checked Base new template on existing one on the General tab, data columns and filters are automatically selected according to the specified template.
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. This option is checked by default if you are creating a new template that is not based on an existing template. Uncheck to hide all unselected events in the Events Selection grid.
Show all columns
Show all available data columns. This option is checked by default if you are creating a new template that is not based on an existing template. Uncheck 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 data column label. Use the Edit Filter dialog box to edit data column filters.
Changes the order of columns in the trace and groups results by one or more columns.