| title | titleSuffix | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.collection | |
|---|---|---|---|---|---|---|---|---|---|---|---|
Create a Trace Template |
SQL Server Profiler |
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. |
rwestMSFT |
randolphwest |
maghan |
12/26/2022 |
sql |
profiler |
how-to |
|
[!INCLUDE SQL Server Azure SQL Managed Instance]
This article describes how to create a new trace template by using [!INCLUDEssSqlProfiler].
-
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.