Home > Articles > Data > SQL Server

  • Print
  • + Share This
Like this article? We recommend

Profiler Templates

SQL Server comes with eight built-in trace templates that can help you get started. Templates simply save your selection of the events, data columns, and filters. To use one of the built-in templates for your trace, simply start a new trace and specify the path to the desired template in the Template File Name box within Trace Properties dialog shown in Figure 1.

Figure 1

Figure 1 You can use one of the eight built-in trace templates for your trace.

In addition to built-in templates, you can also create your own templates. This is a handy shortcut if you like the trace you have recorded and want to reuse it in the future—after all, picking dozens of events and data columns each time you record a trace can be tedious. To create a new trace template, simply choose File, New, Trace Template with the Profiler; choose the events, data columns, and filters; and save the template. The next time you want to use this template, you can pick it just like you would the built-in templates.

Let’s take a quick look at each of the built-in Profiler templates and see when each one of them could be useful:

View Table

  • + Share This
  • 🔖 Save To Your Account