Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to: Filter SPIDs in a Trace (SQL Server Profiler)
Collapse the table of content
Expand the table of content

How to: Filter SPIDs in a Trace (SQL Server Profiler)

This topic describes how to filter server process identifiers (SPIDs) in a trace by using SQL Server Profiler.

To filter system IDs in a trace

  1. On the File menu, click New Trace, and then connect to an instance of SQL Server.

    The Trace Propertiesdialog box appears.

    NoteNote

    if Start tracing immediately after making connectionis selected, the Trace Propertiesdialog box fails to appear, and the trace begins instead. To turn off this setting, on the Toolsmenu, click Options, and clear the Start tracing immediately after making connection check box.

  2. In the Trace name box, type a name for the trace.

  3. In the Use the templatename list, select a trace template.

  4. Optionally, specify a destination file or table in which to save the trace results.

  5. On the Events Selectiontab, click the SPIDcolumn heading to launch the Edit Filter dialog box. You can also right-click the column heading and choose Edit Column Filter. If the SPID column does not appear, check the Show all columns box.

  6. In the Edit Filter dialog box, expand the appropriate comparison operator, and enter a SPID as a value for the comparison.

Community Additions

ADD
Show:
© 2015 Microsoft