So you want to be able to optimise your hybrid production databases but concerned about licensing,  performance and compute costs?

In this session attendees will learn how to record workloads from production instances and replay them either on-prem or on to  Azure instances (VMs and managed instances) and compare workload profiles (ie. wait times, time of day), identify bottlenecks and explore SQL tuning techniques.

We can show you how to justify modifying VM resources and compare the impact on performance to get the right balance of performance and cost, and also tuning queries to reduce IO or CPU.

 We will also demonstrate how to replay production workloads in a test/development environment. Ensuring a high accuracy of regression testing in CI/CD.

Presented by Martin Wild at SQLBits 2020