Chapter 7
Azure SQL Database Elastic Pools
Learning Objectives
By the end of this lesson, you will be able to:
- Explain the purpose of elastic pools
- Identify when to use elastic pools
- Select the size of an elastic pool
- Configure Elastic Database Jobs
This lesson teaches you to save costs and manage and scale multiple SQL databases by using elastic pools. You'll also learn how to implement Elastic Database Jobs to manage and maintain databases in an elastic pool.
Introducing Elastic Pools
Azure SQL Database Elastic Pool is a cost-effective solution for managing and scaling a group or a pool of Azure SQL databases, with a utilization pattern characterized by low average utilization and infrequent spikes.
Figure 7.1: Elastic pools
Get Professional Azure SQL Database Administration - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
