9.1.3 Filtering a Trace

Table of Contents Previous Next



Click the Filter icon to open the Trace Filter dialog and create a rule (or set of rules) that define a filter. Each rule will screen the events within the current trace based on the identity of the role that invoked the event, or the query type invoked during the event.
To open an existing filter, select the Open button; to define a new filter, click the Add (+) icon to add a row to the table displayed on the General tab and provide rule details:
Use the Type drop-down listbox to specify the trace field that the filter rule will apply to.
Use the Condition drop-down listbox to specify the type of operator that SQL Profiler will apply to the Value when it filters the trace:
o
Select Matches to filter events that contain the specified Value.
o
Select Does not match to filter events that do not contain the specified Value.
o
Select Is equal to to filter events that contain an exact match to the string specified in the Value field.
o
Select Is not equal to to filter events that do not contain an exact match to the string specified in the Value field.
o
Select Starts with to filter events that begin with the string specified in the Value field.
o
Select Does not start with to filter events that do not begin with the string specified in the Value field.
o
Select Less than to filter events that have a numeric value less than the number specified in the Value field.
o
Select Greater than to filter events that have a numeric value greater than the number specified in the Value field.
o
Select Less than or equal to to filter events that have a numeric value less than or equal to the number specified in the Value field.
o
Select Greater than or equal to to filter events that have a numeric value greater than or equal to the number specified in the Value field.
Use the Value field to specify the string, number or regular expression that SQL Profiler will search for.
When you've finished defining a rule, click the Add (+) icon to add another rule to the filter. To delete a rule from a filter, highlight the rule and click the Delete icon.
Click the Save button to save the filter definition to a file without applying the filter; to apply the filter, click OK. Select Cancel to exit the dialog and discard any changes to the filter.


Table of Contents Previous Next