About Show #353
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!
Boris is a SQL Server Consultant and Pluralsight Author from Bulgaria who you can regularly see speaking at conferences all across Europe. He is also training companies and students in the “Art of SQL Server” and loves to share his knowledge online as part of podcasts, webcasts or on his blog – http://borishristov.com/blog/. The fastest way you can reach him is on twitter where he writes under @BorisHristov and you can even join him for a SQLHangout which are video conversations that he hosts with people from the SQL Server community.