The ability to replay a production database workload in controlled circumstances can be very useful for testing, in both functionality and performance testing. In this course, Simulating Production Workloads with SQL Server Distributed Replay, you will learn how Distributed Replay offers a way to replay a workload from multiple clients, preserving the order of operations in the process. First, you will go through the setup of Distributed Replay (DReplay). Next, you will explore all the necessary configurations in order to capture, process, and run a replay. Finally, you will discover options for monitoring the effects of running the trace. By the end of this course, you will have a foundational understanding of SQL Server Distributed Reply and how it can help you recreate a production database’s workload on another server.
Author Name: Gail Shaw
Author Description:
Gail is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She is a frequent poster on the SQL Server Central forums, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQL Saturday… more

Table of Contents

• Course Overview
  1min
• Introduction to Distributed Replay
  3mins
• Installing and Configuring Distributed Replay
  18mins
• Capturing and Preprocessing Traces
  13mins
• Replaying Traces and Capturing Results
  19mins
• Summary and Further Reading
  3mins