© Peter A. Carter 2019
P. A. CarterPro SQL Server 2019 Administrationhttps://doi.org/10.1007/978-1-4842-5089-1_21

21. Distributed Replay

Peter A. Carter1 
(1)
SOUTHAMPTON, UK
 

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

Get Pro SQL Server 2019 Administration: A Guide for the Modern DBA 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.