| title | Stop a Trace (SQL Server Profiler) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/01/2017 | ||
| ms.prod | sql-non-specified | ||
| ms.prod_service | sql-tools | ||
| ms.service | |||
| ms.component | sql-server-profiler | ||
| ms.reviewer | |||
| ms.suite | sql | ||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | article | ||
| helpviewer_keywords |
|
||
| ms.assetid | 47c4f33d-63e0-4444-bec8-4c1c91f8e25c | ||
| caps.latest.revision | 22 | ||
| author | stevestein | ||
| ms.author | sstein | ||
| manager | craigg | ||
| ms.workload | Inactive |
[!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.