Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Pause a Trace (SQL Server Profiler)

Pausing a trace prevents further event data from being captured until the trace is restarted.

When you pause a trace, you prevent event data from being captured until the trace is restarted. Restarting a trace lets trace operations resume. No previously captured data is lost after a restart. When the trace is restarted, data capturing resumes from that point onward. While a trace is paused, you can change the name, events, columns, and filters. However, you cannot change the destinations to which you are sending the trace data, nor change the server connection.

To pause a trace

  1. Select a window that contains a running trace.

  2. On the File menu, click Pause Trace.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.