SQL Server Profiler Filter Events

30% OFF - 9th Anniversary discount on Entity Framework Extensions until December 15 with code: ZZZANNIVERSARY9

You can define filters on data columns for SQL Server Profiler trace events so that only those events information are captured that you need.

  • Filtering limits the events and minimizes the overhead in a trace.
  • It is not mandatory to set a filter for a trace.

You add filters to trace definitions by using the Events Selection tab of the Trace Properties dialog.

image
  • The Events Selection tab contains a grid control.
  • The grid control contains each of the traceable event classes in individual rows.
  • The event classes may differ slightly, depending on the type and version of the server to which you are connected.
  • You can identify the event classes in the Events column and are grouped by the event category.
  • The remaining columns list the data columns that can be returned for each event class.

Click on the Column Filters button, and you will see Edit Filter.

image

The Edit Filter dialog contains a list of comparison operators that you can use to filter events in a trace.

image

To apply a filter, click the Duration column heading, expand Greater than or Less than, and then enter a 100000 value in the field that appears beneath the comparison operator.

You can also check the Exclude rows that do not contain values checkbox and then click the OK button.

image

Now you will see only those rows which have Duration greater than 100000 ms.



Got any SQL Server Profiler Question?