AS we now Azure SQL Single database is one from deployment Azure Database models if you need to know more information check this post-Azure Database Deployment model options today I am writing about Fundamental information for Azure Single Database
For More Azure Database Articles Check this Link and If you are Preparing for AZ-103 Azure Administrator Certification check this Article
- The Single Database deployment option creates a single isolated database in Azure SQL Database
- Azure Single Database Support DTU-based and Vcore-based Purchased Model
- The internal of SQL Database server is hidden from the end-user and all are managed by Microsoft Azure
- Azure Single Database has it is own Resources (DTU or V-Core) and this resource will not be shared with other databases in the same single instance. Each Database has dedicated resources.
- Single Database Isolated meaning if you created two single databases on the same single database server each Database has dedicated resources and the two databases cannot be communicated together and I think this one is a security feature
- This means Azure Single Database is the best option for small workloads with applications connects to one DB.
- To Provision Azure SQL Single Database, you need (resource Group, Database name, Server Name, User Name, Password, Location, deployment option either single or elastic pool, Compute Storage and purchase model either DTU-based or vCore-based)
- In Azure SQL Single database provisioning you can create new or select existing one from (Resource group and Server name)
- In Azure SQL Single database provisioning the (resource Group, Database name, Server Name) Should be a unique name.
Azure Single Database Compute + Storage
While deploying the Azure Single 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 Single database supported the DTU-based with 3 services tier (basic, Stander, premium) and supported also the vCore-based with 3 services tier (General Purpose, Business-critical, Hyperscale)
I will not talk more about the details of each options 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 Database Purchase Model (DTU, V-Core) https://docs.microsoft.com/en-us/azure/sql-database/sql-database-purchase-models
- Azure Database Service Tier for DTU Purchase model (basic, Stander, Premium) and this one supported only the Azure database single and elastic pool deployment model https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers-dtu
- Azure Database Service Tier for V-Core Purchase model ( General Purpose, BC Business-critical, Hyperscale) https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers-vcore?tabs=azure-portal
- Resource limits for single databases using the DTU purchasing model https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dtu-resource-limits-single-databases
- Basic Service Tier on DTU-based Purchase model for Single Database https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dtu-resource-limits-single-databases#basic-service-tier
- Stander Service Tier on DTU-based Purchase model for Single Database https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dtu-resource-limits-single-databases#standard-service-tier
- Premium Service Tier on DTU-based Purchase model for Single Database https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dtu-resource-limits-single-databases#premium-service-tier
Azure Single Database Provision
I created one GIF File by the Full Steps for How to Provision Azure SQL Single Database you can download it from 👇 below link or you can view it online also by clicking on download Button. I hope it is helpful and useful.