| title | Create a Trace Template | |
|---|---|---|
| titleSuffix | SQL Server Profiler | |
| description | Discover how to create a new trace template in SQL Server Profiler. Learn how to add filters to the template and how to add or remove events and data columns. | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.reviewer | maghan | |
| 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 create a new trace template by using [!INCLUDE ssSqlProfiler].
-
On the File menu, point to Templates, and then select New Template.
-
In the Trace Template Properties dialog box, select a server type from the Select server type list.
-
In the New template name box, enter a template name.
-
Optionally, select Base new template on existing one, and then select a template from the list.
All events, data columns, and filters are initially set as specified in the selected template.
-
Optionally, select Use as a default template for selected server type.
-
On the Events Selection tab, add, remove, or modify events, data columns, or filters.
-
On the Events Selection tab, use the grid control to add or remove events and data columns from the trace file as follows:
-
To add an event, expand the appropriate event category in the Events column and select the event name.
-
All relevant data columns are included by default when you add an event. To remove a data column for an event from a trace, clear the check box in the data column for the event.
-
To add filters, select the data column name and specify the filter criteria in the Edit Filter dialog box. You can also right-click the data column name and select Edit Column Filter to launch the Edit Filter dialog box. Select OK to add the filter.
-
-
Select Save.