To view filter information
To view filter information
Or
| To list this type of information | View this type of filter |
Using this SQL Server Profiler extended stored procedure |
|---|---|---|
| Application name | Application | xp_trace_getappfilter |
| Connection identification number | Connection ID | xp_trace_getconnectionidfilter |
| CPU usage | CPU | xp_trace_getcpufilter |
| Database identification number | Database ID | xp_trace_getdbidfilter |
| Event duration | Duration | xp_trace_getdurationfilter |
| Specific events | Event | xp_trace_geteventfilter |
| Events to trace | Events Required | xp_trace_geteventnames |
| Host computer name | Host | xp_trace_gethostfilter |
| Host process identification number | Host Process ID | xp_trace_gethpidfilter |
| Index identification number | Index ID | xp_trace_getindidfilter |
| Microsoft® Windows NT® domain name | Windows NT Domain Name | xp_trace_getntdmfilter |
| Windows NT username | Windows NT User Name | xp_trace_getntnmfilter |
| Object identification number | Object ID | xp_trace_getobjidfilter |
| Determine status of a specified trace queue for automatic start | Queue automatic start | xp_trace_getqueueautostart |
| Destination | Queue Destination | xp_trace_getqueuedestination |
| All queue information | Queue properties | xp_trace_getqueueproperties |
| Number of cumulative process read operations | Read | xp_trace_getreadfilter |
| Server name | Server | xp_trace_getserverfilter |
| Severity level | Severity | xp_trace_getseverityfilter |
| System process identification number | System Process ID (SPID) | xp_trace_getspidfilter |
| Determine status of capturing system objects | System objects filter | xp_trace_getsysobjectsfilter |
| Text to include or exclude | Text filter | xp_trace_gettextfilter |
| Username | User | xp_trace_getuserfilter |
| Number of cumulative write operations | Write | xp_trace_getwritefilter |
| Viewing and Analyzing Traces | System Stored Procedures (SQL Server Profiler Extended Procedures) |