Replay your workload as it is your actual one!

50 %
50 %
Information about Replay your workload as it is your actual one!

Published on March 7, 2014

Author: brshristov



Have you ever wanted to replay your application workload be that because you upgraded to a new hardware, added new indexes or something else? Now there's a feature for that! It's called Distributed Replay and in this session you will learn how this new feature in SQL Server 2012 can help you resolve that problem!

Replay your workload as it’s your actual one! Boris Hristov SQL Server DBA, Speaker, Trainer, Blogger

Our Sponsors

So who am I? @BorisHristov

How many of you…

Possible scenarios: 1. Application compatibility 2. Performance / Load testing 3. Forecasting

What tools did we have till now?

The Mighty Profiler

RML Tools ReadTrace Reporter OSTRESS

These are cool… … but are just not cool enough!

“There’s a new player in town!” DISTRIBUTED REPLAY

So what’s Distributed Replay? SQL Server 2012 feature Available in all editions (kind of…) Works with 2005 and higher (kind of…)

Distributed Replay Components 1.  Administration tool – the cmd tool to manage the replay 2.  DReplay Controller – the brain behind the replay 3.  DReplay Client – machines(up to 16) that replay the workload 4.  Target Server – The SQL Server instance you replay against

OK, but how are they working together?

DEMO Setting up DReplay Environment (installing gotchas)

Installation requirements and gotchas 1.  Services must run under domain user accounts 2.  Firewalls must allow the traffic of DR Components 3.  DCOM permissions must be configured 4.  SQL Server logins for the clients need to be created

So how do we issue a replay?

Step 1: Capture a trace!

Step 2: Preprocesses the .trc file/s

Step 3: Decide on replay mode and options

Step 4: Replay the preprocessed trace

DEMO The Replay Process!

Replay your workload. The steps. 1.  Capture the workload with Profiler (TSQL-Replay) 2.  Preprocess the trace with “dreplay preprocess” 3.  Decide on a mode – synchronization or stress 4.  Replay the workload with “dreplay replay” 5.  Analyze the results

The GUI that is in beta from 2011

At the end 1.  The Tool for replaying mission critical workloads 2.  Don’t be afraid of not having a GUI 3.  Capture -> Preprocess -> Replay 4.  Document, blog, share it with the community!

Resources My blog – FAQ and RunAs Radio Podcast Channel 9 - Joe Sack(SQLSkills) Intro and Demo Jonathan Kehayias(SQLSkills) Intro and Demo Microsoft Peace of Mind Video MSDN Documentation Distributed Replay GUI (in beta) … you and me now


Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

Replay your workload as it is your actual one! - Technology

×Close Share Replay your workload as it is your actual one! Embed ...
Read more

Oracle Database Replay for your Workload Test – All Things ...

... Database replay will simulate your actual ... to bring down one instance when ... titled Oracle Database Replay for your Workload ...
Read more

Oracle Database 11g: The Top New Features for DBAs and ...

... the production one, apply a workload similar to your ... the actual replay ... the Database Replay. Just capture the workload during ...
Read more

RML Utilities Archives - Boris Hristov

Replay your workload as it is your actual one! ... Replay your workload as it is your actual one! from Boris Hristov. The nightmare of locking, ...
Read more

Capturing, replaying, and creating a report for a workload

Use the InfoSphere Workload Replay web ... to your InfoSphere Optim™ Workload Replay ... workload from one InfoSphere Workload Replay server to ...
Read more

SQLSaturday #280 - Vienna 2014 > Event Home

Replay your workload as it's your actual one! Boris Hristov. SQL anti patterns. Kennie Pontoppidan. FILETABLEs: ... Brought to you by your local PASS ...
Read more

3 Use Cases for Optim Workload Replay | Dave Beulke

3 Use Cases for Optim Workload Replay. ... Workload Replay for real testing. One of the biggest ... Optim Workload Replay can be used to run your actual ...
Read more

SQLSaturday #274 - Slovenia 2013 > Event Home

Replay your workload as it's your actual one! Boris Hristov. FILETABLEs: What They Are and How to Use Them. Matija Lah. Automate your SSIS development with ...
Read more