It contains transient and cache data such as plan cache, buffer pool, column store pool. Stateless compute layer that runs sqlserver.exe process.The general-purpose service tier has two layers. Note: All images in this article are referenced from Microsoft documentation.It offers 99.99% SLA and storage latency between 5 to 10 milliseconds. The general purpose is the default service tier for the generic workload. The vCore model has the following service tiers. During the pause period, Azure does not charge you for the compute resources. Serverless compute tier: Azure automatically pauses and resumes the database based on workload activity in the serverless tier. Provisioned compute tier: You choose the exact compute resources for the workload. In this purchasing model of Azure SQL Database, you can choose from the provisioned compute tier and serverless compute tier. The term vCore refers to the Virtual Core. The following table compares the Basic, Standard, and Premium service tiers.
You can easily migrate to another service tier however, it requires minimal downtime during the switch-over period. This solution is suitable for clients who look for a predefined resource configuration with a balanced CPU, Memory, and IO.Īzure SQL Databases provides Basic, Standard, and Premium service tiers for different ranges of compute, storage. However, you can increase the number of DTUs to increase the resources for the Azure database. You cannot increase individual resources such as memory or CPU. The Database Transaction Unit (DTU) combines the compute (CPU), memory, IOPS. It enables you to move to a fully managed Platform as a Service (PaaS) with desired performance and cost-effectiveness.Īzure SQL Databases has two pricing models – DTUs and vCores. Azure SQL Database is a popular choice for migrating your database from on-premises to cloud infrastructure.