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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.