Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Azure SQL Managed Instance
The trace definition default is the default trace template that is used for each provider or server. You can set default trace templates for SQL Server or for Analysis Services.
On the File menu, select Templates, and then click Edit Template.
In the Trace Template Properties dialog box, on the Generaltab, select a server type from the Select server typelist.
In the Select template namelist, select the name of the template that you want to use as the trace definition default.
Select Use as a default template for selected server type.
If necessary, click the Events Selectiontab to modify the template.
Click Save.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Configure SQL Server resources for optimal performance - Training
Configure SQL Server resources for optimal performance
Documentation
Modify Trace Templates - SQL Server Profiler
Discover how to modify trace templates in SQL Server Profiler. Add or remove event classes and data columns, and change filters.
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.
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.