| title | Stop a Trace |
|---|---|
| titleSuffix | SQL Server Profiler |
| description | Discover how to stop a trace that is running in SQL Server Profiler, change any properties you want to adjust, and save the captured data. |
| ms.prod | sql |
| ms.prod_service | sql-tools |
| ms.reviewer | |
| ms.technology | profiler |
| ms.topic | conceptual |
| ms.assetid | 47c4f33d-63e0-4444-bec8-4c1c91f8e25c |
| author | markingmyname |
| ms.author | maghan |
| ms.custom | seo-lt-2019 |
| ms.date | 03/01/2017 |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
This topic describes how to stop a trace that is running by using [!INCLUDEssSqlProfiler].
Stopping a trace stops data from being captured. After a trace is stopped, it cannot be restarted without losing previously captured data, unless the data has been captured to a trace file or trace table. You can also save the collected data to a table or file after stopping a trace. All trace properties that were previously selected are preserved when a trace is stopped. When a trace is stopped, you can change the name, events, columns, and filters.
-
Select a trace that is running.
-
On the File menu, click Stop Trace.