As we know Azure SQL Database elastic pool is one of the Microsoft Azure database deployment model options to know more about these models check this post and to know more about Azure Single Database check this article and if you interested to check all of the Azure SQL Articles check this link, IF you are Preparing for AZ-103 Azure Administrator Certification check this Article

Azure SQL Deployment Model options
  1. Hosting Multiple databases sharing the resources of the DTU and you can specify exactly DTU for each database even you can scale-out and scale-in the DTU based on peak time
  2. Azure SQL Elastic Pool is Collection for Multiple Azure Single Databases
  3. Azure SQL Database elastic pool is the most cost-effective solution for multiple databases
  4. The Databases in Elastic pool are on a single Azure SQL database but all of the databases sharing the same resources of the DTU so if we assume the Elastic pool have 100 DTU and we have 5 databases on the elastic pool all of the 5 databases are sharing the 100 DTU
  5. IF you have for example around 3 Azure Single Database and you need to move them to one Azure SQL Database elastic pool is it applicable the answer yes you can do it
  6. We can host up to 5000 databases on Azure SQL Database elastic pool
  7. Azure SQL Database elastic pool can have up to 45000 DTU
  8. All Databases hosted on the Azure SQL Database elastic pool should be in the same region and the same resource group.
  9. IF you are looking for an economic feature so Azure SQL Database elastic pool is your choice
  10. SQL Database resource limits and resource governance➡️  https://docs.microsoft.com/en-us/azure/sql-database/sql-database-resource-limits-database-server
  11. More information About Azure SQL Database elastic pool ➡️ https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

Azure SQL Database Elastic Pool Compute + Storage

While deploying the Azure SQL Database Elastic Pool you will find one option called (COMPUTE + STORAGE) in this section you will be able to select the Purchase model DTU or Vcore and each one support services tier and each services tier support some kind of storage and some other benefits and limitation in the resource, AS you can see below Azure SQL Database Elastic Pool database supported the DTU-based with 3 services tier (basic, Stander, premium) and supported also the vCore-based with 2 services tier (General Purpose, Business-critical)

  • Azure SQL Database Elastic Pool Not Supported Hyperscale Services Tier Like Azure Single Database
  • Azure SQL Database Elastic Pool Supported General Purpose with Compute Hardware Type Provisioning and not support Compute Hardware Type Serverless like Azure Single Database
Azure SQL Database Elastic Pool Compute + Storage

I will not talk more about the details of each option because it contains a lot of information’s but you can find below the most important articles that can describe and explain each point

Azure SQL Database Elastic Pool Provision

I created one GIF File by the Full Steps for How to Provision Azure SQL Single Database you can download it from 👇 the below link or you can view it online also by clicking on Download Button. I hope it is helpful and useful

Keep Following

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.