How to: Pause a Trace (SQL Server Profiler)
Pausing a trace prevents further event data from being captured until the trace is restarted.
To pause a trace
Select a window that contains a running trace.
On the File menu, click Pause Trace.
See Also