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 |
|
Track(s) |
Data Administration |
|
Tags |
#azure #sql #sqldatabase #performance |
|
Level |
Advanced |
|
Trainer/Speaker |
|
|
Abstract |
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. . |
|
Modules/Topics |
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 |
