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 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