Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Simulating Production Workloads with SQL Server Distributed Replay

via Pluralsight

Overview

The ability to recreate a production database workload on another server is an incredibly useful tool to have. In this course, you will learn to do this with ease on SQL Server’s Distributed Replay.




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.

Syllabus

  • 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

Taught by

Gail Shaw

Reviews

4.8 rating at Pluralsight based on 13 ratings

Start your review of Simulating Production Workloads with SQL Server Distributed Replay

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.