Friday 9:00 AM - 10:10 AM · Room 320-321

Azure SQL Database Hyperscale elastic pools - a deep-dive

Aditya Badramraju

Microsoft, Prinicpal Product Manager

Arvind Shyamsundar

Principal Product Manager, Microsoft

Azure SQL Database offers a very popular deployment option called elastic pools, to help ease the challenges around right-sizing and cost-optimizing resources for a group of databases. In this session, we will dive deep into the latest generation of elastic pools which leverage the Hyperscale cloud-native architecture. Starting with a quick overview of the motivation for using elastic pools, and a quick recap of the Hyperscale tech, we will use demos to show you:

• How Hyperscale elastic pools ("HSEP") implement resource sharing...
• ... while maintaining strong isolation between databases -  What are the performance and capacity limits of each HSEP
• How you can proactively control "noisy neighbor" databases in a HSEP
• How HSEP scales vertically and / or horizontally, and what the impact of such scaling is on your workloads
• How to monitor HSEP effectively using DMVs, Azure Monitor and Database Watcher
• How backups, high availability, and disaster recovery work for databases in a HSEP
• Last but not the least, how HSEP helps in cost optimization - and what you should watch out for as well to manage TCO.

To make best use of this session, some Azure SQL knowledge would help, but it's not necessary. Anyone who plans to run databases in Azure SQL should be aware of elastic pools so that they can benefit from the optimizations they provide. This session will directly help you in understanding how HSEP work and how they may be beneficial to your scenario.