A few weeks ago I had a task to create procedure for testing workload from production server on test environment.It surely wasn't a big deal, but I needed to learn many customer employees to repeat this task on regular basis. I started to look if somehow I could replay SQL trace without using SQL Server Profiler.

I have found one absolutely easy to use solution made by fellow Alex Lee on his webpage.

Replay Trace

A tool that replays SQL trace file in console. This tool replays SQL Profiler trace file against local or remote SQL Server

Download link

Prerequisites

  • NET Framework 2.0
  • SQL Server Management Tools (client tool)

Syntax

ReplayTrace [/S server] [E | /U login /P password] [/Q] [/N #_Of_Threads] [/M0 | /M1] [/DR0 | /DR1] [/DE0 | /DE1]

SQL trace file (file extension .trc ) /S server Replay will be run against this SQL Server instance /E Use Windows Authentication for /S SQL server /U user SQL login name for /S SQL Server /P pwd SQL login password for /S SQL Server /Q Quiet mode. By default, ReplayTrace displays progress every 10 trace events, but if using this option, the status progress will be suppressed. /N # [Replay Options] Number of replay threads /M0 [Replay Options] Replay events in the order they were traced (Default) /M1 [Replay Options] Replay events using multiple threads (Connection level sync) /DR0 [Replay Options] Disable replay results /DR1 [Replay Options] Display replay results (Default) /DE0 [Replay Options] Disable execution time (Default) /DE1 [Replay Options] Display execution time

Usage

C> ReplayTrace.exe test.trc /S . /E /N 10 /M1 /DR0

You can surely find many other useful tools on Alex web, they are grouped into few categories such a security, profiling, configuration,import/export and search. Also communication with Alex was smooth and flawless, with short reaction times to implement proposed changes.

Hope it helps.

BTW If you will find this tools useful for you as I, don't forget to donate good work.

With Regards,

Mike.

More tips and tricks

SMT 00.5.55 Released!
by Michal Tinthofer on 26/11/2018

While we are working hard on a next SMT version we realised that we did not publish updates that happened during the current year, let us please fix that and inform you about new features and enhancements to SMT.

Read more
SMT 1.10 released
by Michal Tinthofer on 25/10/2023

SMT 1.10 changelog

Read more
SMT 00.5.32 Released!
by Michal Tinthofer on 31/08/2017

After some time, we have finally released big set of changes and fixes for currently known issues. Most visible is new Waiting Task report for operational analysis, added timeline button for Index Usage & recommendation, new functionality to search for an

Read more