O'Reilly logo

What's New in SQL Server 2012 by Jon Reade, Rachel Clements

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

Usage

As soon as you know how to use Distributed Replay, it is surprisingly easy. Although there is no GUI tool as yet, there are four straightforward steps to have it up and running. We will learn how to use it in the following example.

Capture

The capture step is not an integral part of Distributed Replay. Instead, SQL Server Profiler is used to produce a trace file, a concept familiar to most DBAs and many developers.

However, be aware that certain columns need to be captured during the trace in order for the trace file to be used with Distributed Replay. These can be set up manually, but there is an easier way. Open SQL Server Profiler and connect to the database server from which you want to create the trace. Select the options shown in the ...

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