Replay the Trace Data
There are four basic steps required to capture and replay a workload using Distributed Replay:
1. Review and configure permissions/security related to Distributed Replay.
2. Capture a workload that can be processed and applied using the Distributed Replay Components. This is typically a trace file that has been captured using the SQL Server Profiler.
3. Preprocess the trace file from the first step using DReplay.exe with the preprocess option.
4. Apply the workload using DReplay.exe with the replay option.
There are other considerations, such as Firewall exceptions, that come into play with Distributed Replay but these 4 steps are core to the process. The following sections cover each one of these steps using examples from ...
Get Microsoft SQL Server 2014 Unleashed 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.
