Using Distributed Replay to load test your SQL Server–Part 2
In the first part of this series, I explained you how to install and get started with Distributed Replay. I continue in this series by showing you how to actually capture and replay workloads.
After we have configured the Distributed Replay as explained in the previous post, we can use the Distributed Replay environment to create the load on the SQL Server.
I posted this article to Microsoft SQL PFE site and it can be found from there