DPS 2020 Training Class - Azure SQL DB Performance Tuning- by Martin Cairney


DPS 2020 Training Class – Azure SQL DB Performance – by Martin Cairney

Visit DPS 2020 More Training Classes Book Now

Pre-Con Title

Maximum ROI – How To Optimise Your Azure SQL Database Platform And Applications


Data Administration


#azure #sql #sqldatabase #performance




Martin Cairney


When you move from SQL Server on-premises to Azure SQL Family of services you will find that there are different performance issues that you need to deal with – things like choosing the correct version such as Hyperscale, Managed Instance, Serverless or SQL Database are all important starting points, but once you have that decision then how can you tweak more performance out of your applications?

With the move to the cloud, factors such as increased latency and restricted resources based on your choice of service and tier come in to focus and you have to consider each of these to maximise your ROI for the choice of platform. You could simply continue to scale up to the next performance level but that involves additional cost and soon your savings from the move from on-premises are wiped out.

To get your database humming along at its peak performance you need to start with your configuration – have you chosen the right tier, is it configured for maximum performance, are you connecting optimally before looking at how to optimise your resource usage and then considering techniques to minimise consumption of your precious DTUs.
In this workshop, we will work through the many layers we can tweak to improve our Azure SQL Database performance with plenty of demos to let you see the impact.



1. Comparison of the different service offerings in the Azure SQL Family and which one to choose for your workload
2. Optimising the configuration for maximum performance
3. Improving latency on connections
4. Identify and remove bad application access patterns
5. Optimisation memory usage with limited resources
6. Identify and mitigate IO constraints
7. Patterns for loading data
8. Using Read Scale-Out to maximise read-only query performance
9. Monitoring methods and tools

Attendee Pre-requisite (if any) Attendees should have a basic understanding of .NET data access methods, entity framework, Azure services and SQL Server internals.
Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

DPS 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

Book Now

Leave a Reply