Jason Irwin Jason Irwin - 1 year ago 96
SQL Question

Tools to Replay Load on a SQL Server

Has anyone come across any good tools (preferably but not necessarily FOSS) that can read a SQL Server (2005/2008) trace file and execute the commands against another database. We are attempting to perform some performance testing on our SQL servers and would like to replicate an actual load.

I have come across but not yet used:

  • JMeter

  • ReplayML

Preferably, the application would be able to use threading to mimic user connections and query execution on the SQL Server.

Answer Source

You can replay a SQL Server Profiler trace against another server using the SQL Server Profiler itself.

See the following Microsoft Reference as a starting point.


Quest Software also have a tool called Benchmark Factory that can be used to perform SQL Server load testing.


Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download