To import a trace definitionAfter you have created a trace definition or imported a trace definition using SQL Server Profiler, you can start, pause, or stop capturing data using the new trace.
When using SQL Server Profiler, starting a trace opens a new trace window (if one is not already open), and data is immediately captured. When using Microsoft® SQL Server™ extended stored procedures, you choose to start a trace either manually or automatically every time SQL Server starts. A soon as the trace is started, data is captured in the event queue.
Pausing a trace prevents further event data from being captured until the trace is restarted (continued). Restarting a trace resumes trace operations. Any previously captured data is not lost. When the trace is restarted, data capturing is resumed from that point onward.
Stopping a trace stops data from being captured. Once a trace is stopped it cannot be restarted without losing any previously captured data, unless the data has been captured to a trace file or trace table, in which case the newly captured data is appended to the trace file or trace table.
To import a trace definition
To start a trace
To automatically start a trace upon the server’s next restart
To determine if a trace is set for automatic start
To pause a trace
To restart a paused trace
To clear a trace window
To close a trace window
To stop a trace