Level: Intermediate
Identifying which queries are running slow on your system is getting easier and easier all the time. But, now that you know which queries are causing the system to slow down and you've made changes to the queries or your indexes, how do you know you've tuned them well enough? SQL Server 2012 has introduced the new utility Distributed Replay as a mechanism for testing your queries to ensure you're getting the performance improvements you planned. This session will walk you through how to set up data collection for Distributed Replay, how to run Distributed Replay, and, most importantly, how to interpret the results that you get from Distributed Replay. You will have more confidence in the performance of your system once you've tested your queries.
You will learn:
- How to gather and prepare data metrics that can be used for Distributed Replay testing sessions
- How to set up your own Distributed Replay environment
- How to run a Distributed Replay playback session and interpret the results from the same