Running Database Engine Tuning Advisor for workload

Trace is a session during which the events are captured and event data is collected. SQL Server supports a few formats for saving this collected trace data, which is known as a workload. We can save trace data (a workload) in one of the following formats:

  • A trace file with .trc extension name
  • A trace file in XML format with .xml extension name
  • A trace table in an SQL Server database

We are going to use trace file .trc for this recipe. For detailed information regarding trace, workload, and different events of trace in profiler, refer Creating a trace or workload recipe in Chapter 1.

In this recipe, we will create a trace with SQL Server Profiler; execute some queries that will be captured in running ...

Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.