O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required