SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server “Denali”: Distributed Replay

Replaying multiple threads of a captured trace in SQL Profiler is difficult, and you are limited to replaying the workload from a single computer.  Distributed Replay is a new multi-threaded replay utility in Denali that solves this problem by allowing you to spread the workload of a trace against multiple servers.  So you will have one database server (target server) but multiple replay clients executing traces (up to 16 clients with each running up to 255 threads), with a control server (replay controller) coordinating it all.  This allows you to do stress testing for multiple production workload scenarios, such as how an upgrade to a later version of SQL Server will affect your application, or if running on a database server with more physical memory will resolve a performance problem, or if running on a database server with more CPU’s will increase throughput.

There is a configuration file to modify settings, such as how much time to wait after a connection is made until it executes the first transaction (connect time) or how much time to wait between transactions (think time).

So after you have application changes, configuration changes, or upgrades, use Distributed Replay to help protect performance by testing the impact of the changes.

Distributed Replay is installed separately from the regular SQL Server install and all commands are run from the command line.

It has two modes: Synchronization Mode, which runs as your workload would run, using the wait times between commands, and Stress Mode, where there is no waiting so it runs as fast as possible to stress your server

The bottom line is Distributed Replay should make load testing much easier.

More Info:

TechEd Video: What’s New in Manageability for Microsoft SQL Server Code-Named “Denali” (10:22 mark to 28:34)

SQL Server Distributed Replay

Distributed Replay Utility Concepts

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.


No comments.

Leave a Comment

Please register or log in to leave a comment.