筛选器可用性取决于数据列。某些数据列无法筛选。可筛选的数据列只能使用部分关系运算符进行筛选，如下表所示。
| 关系运算符 | 运算符 | 说明 |
|---|---|---|
|
类似于 |
LIKE |
指定跟踪事件数据必须类似于输入文本。允许使用多个值。 |
|
不类似于 |
NOT LIKE |
指定跟踪事件数据不能与输入文本类似。允许使用多个值。 |
|
等于 |
= |
指定跟踪事件数据必须等于输入的值。允许使用多个值。 |
|
不等于 |
<> |
指定跟踪事件数据不能等于输入的值。允许使用多个值。 |
|
大于 |
> |
指定跟踪事件数据必须大于输入的值。 |
|
大于或等于 |
>= |
指定跟踪事件数据必须大于或等于输入的值。 |
|
小于 |
< |
指定跟踪事件数据必须小于输入的值。 |
|
小于或等于 |
<= |
指定跟踪事件数据必须小于或等于输入的值。 |
下表列出了可筛选数据列和可用关系运算符。
| 数据列 | 关系运算符 |
|---|---|
|
ApplicationName |
LIKE、NOT LIKE |
|
BigintData1 |
=, <>, >=, <= |
|
BigintData2 |
=, <>, >=, <= |
|
BinaryData |
使用 SQL Server Profiler 筛选此数据列中的事件。有关详细信息，请参阅使用 SQL Server Profiler 筛选跟踪。 |
|
ClientProcessID |
=, <>, >=, <= |
|
ColumnPermissions |
=, <>, >=, <= |
|
CPU |
=, <>, >=, <= |
|
DatabaseID |
=, <>, >=, <= |
|
DatabaseName |
LIKE、NOT LIKE |
|
DBUserName |
LIKE、NOT LIKE |
|
Duration |
=, <>, >=, <= |
|
EndTime |
>=, <= |
|
Error |
=, <>, >=, <= |
|
EventSubClass |
=, <>, >=, <= |
|
FileName |
LIKE、NOT LIKE |
|
GUID |
使用 SQL Server Profiler 筛选此数据列中的事件。有关详细信息，请参阅使用 SQL Server Profiler 筛选跟踪。 |
|
Handle |
=, <>, >=, <= |
|
HostName |
LIKE、NOT LIKE |
|
IndexID |
=, <>, >=, <= |
|
IntegerData |
=, <>, >=, <= |
|
IntegerData2 |
=, <>, >=, <= |
|
IsSystem |
=, <>, >=, <= |
|
LineNumber |
=, <>, >=, <= |
|
LinkedServerName |
LIKE、NOT LIKE |
|
LoginName |
LIKE、NOT LIKE |
|
LoginSid |
使用 SQL Server Profiler 筛选此数据列中的事件。有关详细信息，请参阅使用 SQL Server Profiler 筛选跟踪。 |
|
MethodName |
LIKE、NOT LIKE |
|
Mode |
=, <>, >=, <= |
|
NestLevel |
=, <>, >=, <= |
|
NTDomainName |
LIKE、NOT LIKE |
|
NTUserName |
LIKE、NOT LIKE |
|
ObjectID |
=, <>, >=, <= |
|
ObjectID2 |
=, <>, >=, <= |
|
ObjectName |
LIKE、NOT LIKE |
|
ObjectType |
=, <>, >=, <= |
|
Offset |
=, <>, >=, <= |
|
OwnerID |
=, <>, >=, <= |
|
OwnerName |
LIKE、NOT LIKE |
|
ParentName |
LIKE、NOT LIKE |
|
Permissions |
=, <>, >=, <= |
|
ProviderName |
LIKE、NOT LIKE |
|
Reads |
=, <>, >=, <= |
|
RequestID |
=, <>, >=, <= |
|
RoleName |
LIKE、NOT LIKE |
|
RowCounts |
=, <>, >=, <= |
|
SessionLoginName |
LIKE、NOT LIKE |
|
Severity |
=, <>, >=, <= |
|
SourceDatabaseID |
=, <>, >=, <= |
|
SPID |
=, <>, >=, <= |
|
SqlHandle |
使用 SQL Server Profiler 筛选此数据列中的事件。有关详细信息，请参阅使用 SQL Server Profiler 筛选跟踪。 |
|
StartTime |
>=, <= |
|
State |
=, <>, >=, <= |
|
Success |
=, <>, >=, <= |
|
TargetLoginName |
LIKE、NOT LIKE |
|
TargetLoginSid |
使用 SQL Server Profiler 筛选此数据列中的事件。有关详细信息，请参阅使用 SQL Server Profiler 筛选跟踪。 |
|
TargetUserName |
LIKE、NOT LIKE |
|
TextData 1 |
LIKE、NOT LIKE |
|
TransactionID |
=, <>, >=, <= |
|
Type |
=, <>, >=, <= |
|
Writes |
=, <>, >=, <= |
|
XactSequence |
=, <>, >=, <= |