Skip to content

Latest commit

 

History

History
32 lines (22 loc) · 1.29 KB

stop-a-trace-sql-server-profiler.md

File metadata and controls

32 lines (22 loc) · 1.29 KB
title titleSuffix description author ms.author ms.date ms.service ms.subservice ms.topic ms.collection
Stop a Trace
SQL Server Profiler
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.
rwestMSFT
randolphwest
03/01/2017
sql
profiler
how-to
data-tools

Stop a Trace (SQL Server Profiler)

[!INCLUDE SQL Server Azure SQL Managed Instance]

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.

To stop a trace

  1. Select a trace that is running.

  2. On the File menu, click Stop Trace.

See Also

SQL Server Profiler