Reporting from distributed replay result files;

Category: sql server distributed


SQL_Jay on Thu, 14 Nov 2013 15:38:03

Hi Are there any reporting tools that will analyze the trace files from(T-SQL replay captured from source instance) and the result files from distributed replay so we can compare them? I know we can load these into a db and run our own analysis but if there something out there already we don't want to reinvent the wheel.


Andreas.Wolter on Sat, 15 Mar 2014 13:55:54

What exactly do you want to compare?

Distributed Replay returns some statistics

SQL-Trace contains captured statement and other events along with certain attributes like "duration" on a detail-level

If you want to know if your replay was in any way "better" than the original, you have to trace the replay ;-)