| 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. | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.date | 06/05/2025 | |
| ms.service | sql | |
| ms.subservice | profiler | |
| ms.topic | how-to | |
| ms.collection |
|
[!INCLUDE SQL Server Azure SQL Managed Instance]
This article describes how to stop a trace that is running by using [!INCLUDE ssSqlProfiler].
Stopping a trace stops data from being captured. After a trace is stopped, it can't 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, select Stop Trace.