Introducing elastic database pools in SQL Database

The SQL Database elastic pool is a cost-effective solution for managing and scaling a group or a pool of SQL databases, with a utilization pattern characterized by low average utilization and infrequent spikes.

All databases in an elastic database pool:

• Belong to one Azure SQL server.
• Share a set amount of compute resources indexed by eDTUs (Elastic DTUs) in the DTU purchasing model and vCores in the vCore purchasing model.
• Share a set amount of elastic database pool storage.
• Have a price based on the amount of elastic database pool resources and not individual databases.
• Can scale up to the given maximum amount of eDTUs or vCores.
• Optionally, have a guaranteed minimum number of eDTUs or vCores.

Let's look at a scenario that highlights when we should think about using an SQL Database elastic pool.

When should you consider elastic database pools?

In Chapter 7, Scalability, we worked...