How to continuously optimise your hybrid SQL Server estate

Automate optimising your hybrid production databases by recording workloads and replaying them either on-prem or onto Azure instances whilst identifying bottlenecks and exploring SQL tuning techniques.

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.

Speaker

Martin Wild is a systems consultant at Quest. Based at the European headquarters in the U.K., Martin is responsible for supporting the UK and EMEA sales team for the Toad portfolio, Database Performance Monitoring and Data Movement solutions.

Martin Wild's Sessions

Meet SQL Server audit and compliance requirements for all instances across your enterprise

Meet SQL Server audit and compliance requirements for all your instances across your enterprise

How to continuously optimise your hybrid SQL Server estate

Monitoring AzureSQLDB

Lifting the lid on SQL Server on Linux

Plan optimization from DBA to Developer