Trace Properties (Events Selection Tab)

Use the Events Selection tab of the Trace Properties dialog box to view or specify traced events and data columns.

Options

  • Events column
    Specify traced events by selecting or clearing the check box in the event column. Events are organized by event category. Event classes specified in the template are automatically selected. For more information, see SQL Server Event Class Reference.

  • Data columns
    Specify traced data columns 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.

    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. For more information, see SQL Server Profiler - Edit Filter.

  • 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.

  • 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.

  • Column Filters
    Launches the Edit Filter dialog box. You can use this dialog 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

Tasks

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)

Concepts

SQL Server Profiler

Other Resources

SQL Server Profiler Templates and Permissions