Richard talks to Boris Hristov about Distributed Transaction Replay in SQL Server 2012. New to SQL Server 2012, Distributed Replay uses a SQL Profiler template to collect transactions that can be replayed on your server. The tool is largely command line, and can be distributed across as many as sixteen clients. Boris talks about the different types of replays that can be done to simulate a workload in detail for testing purposes - say to make sure an upgrade will work properly, or in stress mode, to see what the limits of your SQL Server are. This is a great new tool for your SQL toolbox, check it out!
