Create a Trace Template (SQL Server Profiler)

APPLIES TO: YesSQL Server NoAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

This topic describes how to create a new trace template by using SQL Server Profiler.

To create a trace template

  1. On the File menu, point to Templates, and then click New Template.

  2. In the Trace Template Properties dialog box, select a server type from the Select server typelist.

  3. In the New template name box, enter a template name.

  4. Optionally, click 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.

  5. Optionally, click Use as a default template for selected server type.

  6. On the Events Selection tab, add, remove, or modify events, data columns, or filters.

  7. On the Events Selectiontab, 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 then select the event name.

    • When you add an event, all relevant data columns are included by default. 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, click 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 click Edit Column Filter to launch the Edit Filter dialog box. Click OK to add the filter.

  8. Click Save.

See Also

Specify Events and Data Columns for a Trace File (SQL Server Profiler)
Derive a Template from a Running Trace (SQL Server Profiler)
Derive a Template from a Trace File or Trace Table (SQL Server Profiler)
SQL Server Profiler Templates and Permissions
SQL Server Profiler