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

Applies to: 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 SQL Server Profiler.

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.


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