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

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