How to filter system IDs in a trace (SQL Profiler)

How to filter system IDs in a trace (SQL Profiler)

To filter system IDs in a trace

1. On the File menu, point to New, and then click Trace.
   
   
2. In the Connect to SQL Server dialog box, select the server to which you want to connect and a connection method.
   
   
3. In the Trace Properties dialog box, do the following:
   • In the Trace name box, type a name for the trace.
     
     
   • In the Template name list, select a trace template.
     
     
   • Optionally, specify a save destination for the trace results.
4. Click the Filters tab, and then in the Trace event criteria box, expand SPID.
   
   
5. Expand Equals, Not equal to, Greater than or equal or Less than or equal, and then enter a value in the field that appears beneath the criterion.

See Also

Monitoring with SQL Profiler