Distributed Replay is a utility supplied with SQL Server that offers you the ability to replay traces on one or more clients and dispatch the events to a target server. This is useful for scenarios in which you are testing the impact of software updates, such as OS-level and SQL Server–level service packs, testing performance tuning, load testing, and consolidation planning.
In older versions of SQL Server, SQL Trace and its GUI, Profiler, were commonly used to both generate traces and replay them. This had limitations, however, such as the overhead to capture the trace and the ...