Replay your workload as it is your actual one!

Technology

boris-hristov
  • 1.Replay your workload as it’s your actual one! Boris Hristov SQL Server DBA, Speaker, Trainer, Blogger21.12.2013
  • 2. Thank you to all our SPONORS! GoldSilver21.12.2013Bronze
  • 3. So who am I?@BorisHristov21.12.2013
  • 4. How many of you…21.12.2013
  • 5. Possible scenarios: 1. Application compatibility2. Performance / Load testing 3. Forecasting21.12.2013
  • 6. What tools did we have till now?21.12.2013
  • 7. The Mighty Profiler21.12.2013
  • 8. RML ToolsReadTraceReporterOSTRESS21.12.2013
  • 9. These are cool… … but are just not cool enough!21.12.2013
  • 10. “There’s a new player in town!” DISTRIBUTED REPLAY21.12.2013
  • 11. So what’s Distributed Replay? SQL Server 2012 feature Available in all editions (kind of…) Works with 2005 and higher (kind of…)21.12.2013
  • 12. Distributed Replay Components 1. Administration tool – the cmd tool to manage the replay2. 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 against21.12.2013
  • 13. OK, but how are they working together?21.12.2013
  • 14. DEMO Setting up DReplay Environment (installing gotchas)21.12.2013
  • 15. 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 created21.12.2013
  • 16. So how do we issue a replay?21.12.2013
  • 17. Step 1: Capture a trace!21.12.2013
  • 18. Step 2: Preprocesses the .trc file/s21.12.2013
  • 19. Step 3: Decide on replay mode and options21.12.2013
  • 20. Step 4: Replay the preprocessed trace21.12.2013
  • 21. DEMO The Replay Process!21.12.2013
  • 22. 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 results21.12.2013
  • 23. The GUI that is in beta from 201121.12.2013
  • 24. At the end 1. The Tool for replaying mission critical workloads 1. Don’t be afraid of not having a GUI 2. Capture -> Preprocess -> Replay 3. Document, blog, share it with the community!21.12.2013
  • 25. Resources Channel 9 - Joe Sack(SQLSkills) Intro and Demo blog posts Jonathan Kehayias(SQLSkills) Intro and Demo blog posts Microsoft Peace of Mind Video MSDN Documentation Distributed Replay GUI (in beta) … you and me now21.12.2013
  • 26. Thank you!21.12.2013
    Please download to view
  • 1
    All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
    Description
    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!
    Text
    • 1.Replay your workload as it’s your actual one! Boris Hristov SQL Server DBA, Speaker, Trainer, Blogger21.12.2013
  • 2. Thank you to all our SPONORS! GoldSilver21.12.2013Bronze
  • 3. So who am I?@BorisHristov21.12.2013
  • 4. How many of you…21.12.2013
  • 5. Possible scenarios: 1. Application compatibility2. Performance / Load testing 3. Forecasting21.12.2013
  • 6. What tools did we have till now?21.12.2013
  • 7. The Mighty Profiler21.12.2013
  • 8. RML ToolsReadTraceReporterOSTRESS21.12.2013
  • 9. These are cool… … but are just not cool enough!21.12.2013
  • 10. “There’s a new player in town!” DISTRIBUTED REPLAY21.12.2013
  • 11. So what’s Distributed Replay? SQL Server 2012 feature Available in all editions (kind of…) Works with 2005 and higher (kind of…)21.12.2013
  • 12. Distributed Replay Components 1. Administration tool – the cmd tool to manage the replay2. 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 against21.12.2013
  • 13. OK, but how are they working together?21.12.2013
  • 14. DEMO Setting up DReplay Environment (installing gotchas)21.12.2013
  • 15. 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 created21.12.2013
  • 16. So how do we issue a replay?21.12.2013
  • 17. Step 1: Capture a trace!21.12.2013
  • 18. Step 2: Preprocesses the .trc file/s21.12.2013
  • 19. Step 3: Decide on replay mode and options21.12.2013
  • 20. Step 4: Replay the preprocessed trace21.12.2013
  • 21. DEMO The Replay Process!21.12.2013
  • 22. 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 results21.12.2013
  • 23. The GUI that is in beta from 201121.12.2013
  • 24. At the end 1. The Tool for replaying mission critical workloads 1. Don’t be afraid of not having a GUI 2. Capture -> Preprocess -> Replay 3. Document, blog, share it with the community!21.12.2013
  • 25. Resources Channel 9 - Joe Sack(SQLSkills) Intro and Demo blog posts Jonathan Kehayias(SQLSkills) Intro and Demo blog posts Microsoft Peace of Mind Video MSDN Documentation Distributed Replay GUI (in beta) … you and me now21.12.2013
  • 26. Thank you!21.12.2013
  • Comments
    Top