Chapter 7. Elastic Pools
This chapter teaches you about how to save costs, and manage and scale multiple SQL databases by using elastic pools. You'll also learn how to implement elastic jobs to manage and maintain databases in an elastic pool.
By the end of this chapter, you will be able to:
- Explain the purpose of elastic pools
- Identify when to use elastic pools
- Select the size an elastic pool
- Configure elastic jobs
Introducing Elastic Pools
An Azure SQL Database Elastic Pool is a cost-effective solution for managing and scaling a group or pool of multiple Azure SQL Databases, with the utilization pattern characterized by low average utilization and infrequent spikes.
Figure 7.1: Elastic Pools
All databases in an elastic pool:
- Belong to one Azure SQL ...
Get Professional Azure SQL Database Administration 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.
