Trace Template Properties (Events Selection Tab)

  • Article

 

Applies To: SQL Server 2016

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.

Options

Events column
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.

Data columns
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.

Column Filters
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.

Organize Columns
Changes the order of columns in the trace and groups results by one or more columns.

See Also

Specify Events and Data Columns for a Trace File (SQL Server Profiler)
Organize Columns Displayed in a Trace (SQL Server Profiler)
Filter Events in a Trace (SQL Server Profiler)
View Filter Information (SQL Server Profiler)
Modify a Filter (SQL Server Profiler)
SQL Server Profiler Templates and Permissions
SQL Server Profiler