SQL Server Performance

Looking for steps to capture workload from production and replay on test env.

Discussion in 'ALL SQL SERVER QUESTIONS' started by Frank.svs, Mar 11, 2014.

  1. Frank.svs New Member

    Hi Experts,

    I want to perform performance testing on my test server?
    How to capture workload from production and replay on test server?
    Basically looking for detailed steps so that I can repro the same workload from production to test env.

    Thanks in Advance.
  2. Trev256b Member

    hi frank - easy - start with using sql profiler - capture a trace and replay - let me know how u get on. :)

Share This Page