Reader small image

You're reading from  Azure for Architects. - Second Edition

Product typeBook
Published inJan 2019
PublisherPackt
ISBN-139781789614503
Edition2nd Edition
Tools
Right arrow
Author (1)
Ritesh Modi
Ritesh Modi
author image
Ritesh Modi

Ritesh Modi is a technologist with more than 18 years of experience. He holds a master's degree in science in AI/ML from LJMU. He has been recognized as a Microsoft Regional Director for his contributions to building tech communities, products, and services. He has published more than 10 tech books in the past and is a cloud architect, speaker, and leader who is popular for his contributions to data centers, Azure, Kubernetes, blockchain, cognitive services, DevOps, AI, and automation.
Read more about Ritesh Modi

Right arrow

Elastic pools

An elastic pool is a logical container that can host multiple databases in a single logical server. The SKUs available for elastic pools are as follows:

  • Basic
  • Standard
  • Premium

The following screenshot shows the maximum amount of DTUs that can be provisioned for each SKU:

All the features discussed for Azure SQL single instances are available to elastic pools as well; however, horizontal scalability is an additional feature it provides with the help of shading. Shading refers to the vertical or horizontal partitioning of data and the storing of it into separate databases. It is also possible to have auto-scaling of individual databases in an elastic pool by consuming more DTUs than are actually allocated to that database.

Elastic pools also provide another advantage in terms of cost. We will see in a later section that Azure SQL is priced using the concept of DTUs...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Azure for Architects. - Second Edition
Published in: Jan 2019Publisher: PacktISBN-13: 9781789614503

Author (1)

author image
Ritesh Modi

Ritesh Modi is a technologist with more than 18 years of experience. He holds a master's degree in science in AI/ML from LJMU. He has been recognized as a Microsoft Regional Director for his contributions to building tech communities, products, and services. He has published more than 10 tech books in the past and is a cloud architect, speaker, and leader who is popular for his contributions to data centers, Azure, Kubernetes, blockchain, cognitive services, DevOps, AI, and automation.
Read more about Ritesh Modi