Published on March 7, 2014
Replay your workload as it’s your actual one! Boris Hristov SQL Server DBA, Speaker, Trainer, Blogger
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
×Close Share Replay your workload as it is your actual one! Embed ...
... Database replay will simulate your actual ... to bring down one instance when ... titled Oracle Database Replay for your Workload ...
... the production one, apply a workload similar to your ... the actual replay ... the Database Replay. Just capture the workload during ...
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, ...
Use the InfoSphere Workload Replay web ... to your InfoSphere Optim™ Workload Replay ... workload from one InfoSphere Workload Replay server to ...
Replay your workload as it's your actual one! Boris Hristov. SQL anti patterns. Kennie Pontoppidan. FILETABLEs: ... Brought to you by your local PASS ...
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 ...
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 ...