Skip to content

Latest commit

 

History

History
35 lines (27 loc) · 1.6 KB

derive-a-template-from-a-running-trace-sql-server-profiler.md

File metadata and controls

35 lines (27 loc) · 1.6 KB
title titleSuffix description author ms.author ms.date ms.service ms.subservice ms.topic ms.collection
Derive a Template from a Running Trace
SQL Server Profiler
Discover how to create a template from an existing trace in SQL Server Profiler while the trace is running.
rwestMSFT
randolphwest
03/01/2017
sql
profiler
how-to
data-tools

Derive a Template from a Running Trace (SQL Server Profiler)

[!INCLUDE SQL Server Azure SQL Managed Instance] This topic describes how to create a trace template from an existing trace while it is running by using [!INCLUDEssSqlProfiler].

To derive a template from a running trace

  1. If necessary, switch to the window that contains the trace.

  2. On the File menu, point to Save As, and then click Trace Template.

  3. Type a name or select one from the list. Click OK.

Note

If you select an existing template file, you are asked if you want to overwrite the file. You can only select a user-defined template. Predefined system trace templates cannot be overwritten.

See Also

SQL Server Profiler Templates and Permissions
Create a Trace Template (SQL Server Profiler)
Modify a Trace Template (SQL Server Profiler)
SQL Server Profiler