To set a trace filter
To set a trace filter
| To configure or set this type of information | Set this type of filter |
Using this SQL Server Profiler extended stored procedure |
|---|---|---|
| Application name | Application | xp_trace_setappfilter |
| Connection identification number | Connection ID | xp_trace_setconnectionidfilter |
| CPU usage | CPU | xp_trace_setcpufilter |
| Database identification number | Database ID | xp_trace_setdbidfilter |
| Event duration | Duration | xp_trace_setdurationfilter |
| Events to trace | Events Required | xp_trace_seteventclassrequired |
| Specific events | Event | xp_trace_seteventfilter |
| Host computer name | Host | xp_trace_sethostfilter |
| Host process identification number | Host Process ID | xp_trace_sethpidfilter |
| Index identification number | Index ID | xp_trace_setindidfilter |
| Microsoft® Windows NT® domain name | Windows NT Domain Name | xp_trace_setntdmfilter |
| Windows NT username | Windows NT User Name | xp_trace_setntnmfilter |
| Object identification number | Object ID | xp_trace_setobjidfilter |
| Capture last 100 Microsoft® SQL Server™ events | Query History | xp_trace_setqueryhistory |
| Configure a specified trace queue for automatic start | Queue automatic start | xp_trace_setqueueautostart |
| Modify trace queue properties | Queue creation information | xp_trace_setqueuecreateinfo |
| Destination | Queue Destination | xp_trace_setqueuedestination |
| Number of cumulative process read operations | Read | xp_trace_setreadfilter |
| Server name | Server | xp_trace_setserverfilter |
| Severity level | Severity | xp_trace_setseverityfilter |
| System process identification number | System Process ID (SPID) | xp_trace_setspidfilter |
| Capture system objects | System objects filter | xp_trace_setsysobjectsfilter |
| Text to include or exclude | Text filter | xp_trace_settextfilter |
| Username | User | xp_trace_setuserfilter |
| Number of cumulative write operations | Write | xp_trace_setwritefilter |
| Filtering Events | System Stored Procedures (SQL Server Profiler Extended Procedures) |