Sample Header Ad - 728x90

Capture and Replay workload

8 votes
2 answers
2748 views
We have a new server which we are migrating too and want to see the potential benefits of the hardware. So the idea is that we capture a workload and replay this against our new box. My question is however in regards to seeing the performance benefits. I will be running some perf counters but ideally we want to see how much quicker individual queries are. I will have this information in the initial workload capture, however when I replay this on my new server do I simultaneously need to run a trace to capture the new workload information also. In effect running SQL profiler twice at the same time for replaying and capturing?
Asked by Tom (1569 rep)
May 13, 2015, 09:13 AM
Last activity: Apr 18, 2023, 11:03 AM