Skip to content

set-trace-definition-defaults-sql-server-profiler.md

Latest commit

 

History

History
38 lines (26 loc) · 1.46 KB

set-trace-definition-defaults-sql-server-profiler.md

File metadata and controls

38 lines (26 loc) · 1.46 KB
title Set Trace Definition Defaults
titleSuffix SQL Server Profiler
description Discover how to use SQL Server Profiler to set up the templates that SQL Server and Analysis Services use by default for each provider or server.
author rwestMSFT
ms.author randolphwest
ms.date 06/05/2025
ms.service sql
ms.subservice profiler
ms.topic how-to
ms.collection
data-tools

Set trace definition defaults (SQL Server Profiler)

[!INCLUDE 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 [!INCLUDE ssNoVersion] or for [!INCLUDE ssASnoversion].

Set trace definition defaults

  1. On the File menu, select Templates, and then select Edit Template.

  2. In the Trace Template Properties dialog box, on the General tab, select a server type from the Select server type list.

  3. In the Select template name list, select the name of the template that you want to use as the trace definition default.

  4. Select Use as a default template for selected server type.

  5. If necessary, select the Events Selection tab to modify the template.

  6. Select Save.

Related content