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 ...
Get What's New in SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
