Skip navigation

Azure SQL Database pricing

The intelligent, relational cloud database service

Start your Azure free account and get a $200 credit for 30 days, plus get 12 months of free access to Azure SQL Database.

Azure SQL Database is a fully managed relational database with built-in intelligence supporting self-driving features such as performance tuning and threat alerts. Microsoft performs all the patching and updating of the code base, and manages the underlying infrastructure for you, while you save time and resources. With high SQL Server compatibility, you can also migrate your databases to SQL Database Managed Instance without changing your apps.

Built-in high availability

Help ensure business continuity without extra configuration, replication or database costs.

Flexible and transparent pricing

Customise compute and storage resources based on your workload.

Save up to 55 per cent on vCore-based options*

Migrate your SQL Server licences with active Software Assurance.

Learn more

Migrate virtualised workloads, save more

Move your Enterprise Edition virtualised workloads to SQL Database.

Learn more

Explore all SQL Database pricing options

Find the performance and pricing that fits your workload.

Single Database is best for apps with predictable patterns and relatively stable workloads.

A vCore-based purchase model is best if you are looking for flexibility, control and transparency of individual resource consumption. This model allows you to scale compute, memory and storage based upon your workload needs and provides a straightforward way to translate on-premises workload requirements to the cloud. The vCore model is in preview. Prices reflect general availability rates.

General Purpose

Ideal for most business workloads, offering balanced and scalable compute and storage options.

Gen 4

Gen 4 CPUs are based on Intel E5-2673 v3 (Haswell) 2.4 GHz processors. In Gen 4, 1 vCore = 1 physical CPU

vCORE Memory (GB) Licence-included price Azure Hybrid Benefit1 price (% savings) 1-year reserved licence-included price (% savings)2 3-years reserved licence-included price (% savings)2 3 years reserved with Azure Hybrid Benefit (% savings)2
1 7 $- $- $- $- $-
2 14 $- $- $- $- $-
4 28 $- $- $- $- $-
8 56 $- $- $- $- $-
16 112 $- $- $- $- $-
24 164 $- $- $- $- $-

1Applies to SQL Server Licences with active Software Assurance (SA). Learn more about Azure Hybrid benefit for SQL Server.

2 Learn more about Azure reservations and Azure SQL Database reserved capacity pricing.

Compute is provisioned in virtual cores (vCores) with an option to choose between compute generations.

Gen 5

Gen 5 logical CPUs are based on Intel E5-2673 v4 (Broadwell) 2.3 GHz processors. In Gen 5, 1 vCore = 1 hyper thread

vCORE Memory (GB) Licence-included price Azure Hybrid Benefit1 price (% savings) 1-year reserved licence-included price (% savings)2 3-years reserved licence-included price (% savings)2 3 years reserved with Azure Hybrid Benefit (% savings)2
2 11 $- $- $- $- $-
4 22 $- $- $- $- $-
8 44 $- $- $- $- $-
16 88 $- $- $- $- $-
24 132 $- $- $- $- $-
32 176 $- $- $- $- $-
40 220 $- $- $- $- $-
80 396 $- $- $- $- $-

1Applies to SQL Server Licences with active Software Assurance (SA). Learn more about Azure Hybrid benefit for SQL Server.

2 Learn more about Azure reservations and Azure SQL Database reserved capacity pricing.

Compute is provisioned in virtual cores (vCores) with an option to choose between compute generations.

Storage

In the General Purpose tier, you are charged for Premium Blob Storage that you provision for your database or elastic pool. Storage can be configured between 5 GB and 4 TB with 1 GB increments.

Price
GB/month $-

Backup storage

Seven days of automated backups of your databases are copied to RA-GRS Standard blob storage. The storage is used by weekly full backups, daily differential backups and transaction log backups copied every five minutes. The backup cost depends on the rate of change of the database. A minimum storage amount equal to 100% of database size is provided at no extra charge. Additional consumption of backup storage will be charged in GB/month.

Price
RA-GRS Coming Soon
ZRS Coming Soon
LRS $-

Long-term retention storage

Preview Price
GB/month $-/GB/month

I/Os

Free while in Preview

**Limited-time promotion. I/Os will not be charged until 31 December 2018. Backup storage will not be charged until 31 December 2018.

Business critical

Business apps with high IO requirements. Offers highest resilience to failures using several isolated replicas.

Gen 4

Gen 4 CPUs are based on Intel E5-2673 v3 (Haswell) 2.4 GHz processors. In Gen 4, 1 vCore = 1 physical CPU

vCORE Memory (GB) Licence-included price Azure Hybrid Benefit1 price (% savings) 1-year reserved licence-included price (% savings)2 3-years reserved licence-included price (% savings)2 3 years reserved with Azure Hybrid Benefit (% savings)2
1 7 $- $- $- $- $-
2 14 $- $- $- $- $-
4 28 $- $- $- $- $-
8 56 $- $- $- $- $-
16 112 $- $- $- $- $-
24 157 $- $- $- $- $-

1Applies to SQL Server Licences with active Software Assurance (SA). Learn more about Azure Hybrid benefit for SQL Server.

2 Learn more about Azure reservations and Azure SQL Database reserved capacity pricing.

Compute is provisioned in virtual cores (vCores) with an option to choose between compute generations.

Gen 5

Gen 5 logical CPUs are based on Intel E5-2673 v4 (Broadwell) 2.3 GHz processors. In Gen 5, 1 vCore = 1 hyper thread

vCORE Memory (GB) Licence-included price Azure Hybrid Benefit1 price (% savings) 1-year reserved licence-included price (% savings)2 3-years reserved licence-included price (% savings)2 3 years reserved with Azure Hybrid Benefit (% savings)2
2 11 $- $- $- $- $-
4 22 $- $- $- $- $-
8 44 $- $- $- $- $-
16 88 $- $- $- $- $-
24 132 $- $- $- $- $-
32 176 $- $- $- $- $-
40 220 $- $- $- $- $-
80 396 $- $- $- $- $-

1Applies to SQL Server Licences with active Software Assurance (SA). Learn more about Azure Hybrid benefit for SQL Server.

2 Learn more about Azure reservations and Azure SQL Database reserved capacity pricing.

Compute is provisioned in virtual cores (vCores) with an option to choose between compute generations.

Storage

In the Business Critical tier, you will be charged for local SSD storage that you provision for your database or elastic pool. Storage can be configured between 5 GB and 4 TB with 1 GB increments.

Price
GB/month $-

Backup storage

Seven days of automated backups of your databases are copied to RA-GRS Standard blob storage. The storage is used by weekly full backups, daily differential backups and transaction log backups copied every five minutes. The backup cost depends on the rate of change of the database. A minimum storage amount equal to 100% of database size is provided at no extra charge. Additional consumption of backup storage will be charged in GB/month.

Price
RA-GRS Coming Soon
ZRS Coming Soon
LRS $-

Long-term retention storage

Preview Price
GB/month $-/GB/month

I/Os

Free while in Preview

**Limited-time promotion. I/Os will not be charged until 31 December 2018. Backup storage will not be charged until 31 December 2018.

Hyperscale

Hyperscale provides rapid, dynamic storage scaling up to 100 TB to help you optimise database resources for your workload’s needs. During Preview, an additional read replica is automatically provisioned and is billed at the Azure Hybrid Benefit pricing. The below pricing is for the primary instance.

Gen 4

Gen 4 CPUs are based on Intel E5-2673 v3 (Haswell) 2.4 GHz processors. In Gen 4, 1 vCore = 1 physical CPU

vCORE Memory (GB) Licence-included price Azure Hybrid Benefit1 price (% savings)
1 7 $- $-
2 14 $- $-
4 28 $- $-
8 56 $- $-
16 112 $- $-
24 164 $- $-

1Hyperscale is in public preview. Prices reflect preview rates.

Applies to SQL Server Licences with active Software Assurance (SA). Learn more about Azure Hybrid benefit for SQL Server.

Compute is provisioned in virtual cores (vCores) with an option to choose between compute generations.

Gen 5

Gen 5 logical CPUs are based on Intel E5-2673 v4 (Broadwell) 2.3 GHz processors. In Gen 5, 1 vCore = 1 hyper thread

vCORE Memory (GB) Licence-included price Azure Hybrid Benefit1 price (% savings)
2 11 $- $-
4 22 $- $-
8 44 $- $-
16 88 $- $-
24 132 $- $-
32 176 $- $-
40 220 $- $-
80 396 $- $-

1Hyperscale is in public preview. Prices reflect preview rates.

Applies to SQL Server Licences with active Software Assurance (SA). Learn more about Azure Hybrid benefit for SQL Server.

Compute is provisioned in virtual cores (vCores) with an option to choose between compute generations.

Storage

In the hyperscale tier, you are charged for storage for your database based on actual usage. Storage is dynamically allocated between 5 GB and 100 TB, in 1 GB increments.

Preview Price
GB/month $-

Backup storage**

Seven days of automated backups of your databases are copied to RA-GRS Standard blob storage. The storage is used by weekly full backups, daily differential backups and transaction log backups copied every five minutes. The backup cost depends on the rate of change of the database. A minimum storage amount equal to 100% of database size is provided at no extra charge. Additional consumption of backup storage will be charged in GB/month.

Price
RA-GRS Coming Soon
ZRS Coming Soon
LRS $-

I/Os

Free while in Preview

**Limited-time promotion. I/Os will not be charged until 31 December 2018. Backup storage will not be charged until 31 December 2018.

In DTU-based SQL purchase models, a fixed set of resources is assigned to the database or elastic pool via performance tiers: Basic, Standard and Premium. This model is best for customers who prefer the simplicity of fixed payments each month, where the simplicity of pre-configured options is desired.


Single database model

Single databases are fully isolated databases optimised for workloads when performance demands are somewhat predictable. You can scale a single database up or down through the Basic, Standard and Premium service tiers to get the performance and features your app needs, precisely when it needs it. Each tier is distinguished primarily by performance, which is measured in Database Transaction Units (DTUs). See Service tiers for more details.

Create a database now.

Basic

DTUs Included storage Max storage Price for DTUs and included storage
B 5 2 GB 2 GB $-

Standard

DTUs Included storage Max storage Price for DTUs and included storage 1
S0 10 250 GB 250 GB $-
S1 20 250 GB 250 GB $-
S2 50 250 GB 250 GB $-
S3 100 250 GB 1 TB $-
S4 2 200 250 GB 1 TB $-
S6 2 400 250 GB 1 TB $-
S7 2 800 250 GB 1 TB $-
S9 2 1,600 250 GB 1 TB $-
S12 2 3,000 250 GB 1 TB $-
1An additional cost applies for extra storage that is provisioned above the amount of storage included. Please see the FAQs for details of how this cost is computed.
2The pricing above for S4-S12 reflects the rates for general availability and goes into effect on 1 June 2018. Usage prior to 1 June 2018 will be billed at the preview rates which are 50% of the general availability rate.

Premium

Premium – designed for IO-intensive production workloads with high availability and zero downtime. Premium is fault-tolerant and automatically handles read and write availability with a 99.99% availability SLA.

DTUs Included storage 1 Max storage Price for DTUs and included storage 2
P1 125 500 GB 1 TB $-
P2 250 500 GB 1 TB $-
P4 500 500 GB 1 TB $-
P6 1,000 500 GB 1 TB $-
P11 1,750 4 TB 4 TB $-
P15 4,000 4 TB 4 TB $-
1More than 1 TB of storage in the Premium tier is available in all regions except the following: West Central US, US DoD Central, Germany Central, US DoD East, US Gov. Texas, US Gov. Arizona, US Gov. Virginia, Germany Northeast. More widespread availability is planned. In these regions, the storage max in the Premium tier is limited to 1 TB.
2An additional cost applies for extra storage that is provisioned above the amount of storage included. Please see the FAQs for details of how this cost is computed.

Note: Outbound data transfers are charged at regular data transfer rates.

Extra data storage

Service tier Price 1
Standard $-/GB/month
Premium $-/GB/month
Extra storage is only available in the Standard and Premium service tiers. 1The pricing for extra storage reflects the rates for general availability and will be effective from 1 August 2018. Usage prior to 1 August 2018 will be billed at the preview rates which are 50% of the general availability rate.

Backup storage

Preview Price
Long-term retention storage $-/GB/month

Active geo-replication (opt-in feature)

Active geo-replication creates up to four online (readable) secondaries in any Azure region. Secondary active geo-replication databases are priced at 100 per cent of primary database prices. The cost of geo-replication traffic between the primary and the online secondary is included in the cost of the online secondary. Active geo-replication is available for all database tiers.

Advanced Threat Protection

SQL Advanced Threat Protection (ATP) – Please see Azure Security Centre pricing page for details.

Dev/Test pricing available

Discounted Azure pricing is available for Visual Studio subscribers looking to run development and testing workloads, individually or as a team. Active Visual Studio subscribers can take advantage of a wide range of discounts when using an Azure subscription based on a dev/test offer. Learn more about dev/test offers and Visual Studio subscriptions.

Support and SLA

  • Free billing and subscription management support
  • Flexible support plans starting at $29/month. Find a plan
  • Guaranteed 99.99% uptime for SQL Database (excludes preview services). Read the SLA

Frequently asked questions (FAQs)

Azure SQL Database pricing

  • A virtual core (vCore) represents the logical CPU available for your server, offered with a choice of hardware generations. For servers created using Gen4 vCores, the vCores are based on Intel E5-2673 v3 (Haswell) 2.4 GHz processors. For servers created using Gen5 vCores, the vCores are based on Intel E5-2673 v4 (Broadwell) 2.3 GHz processors.

  • The vCore-based purchasing model gives you more flexibility and control, and a straightforward way to translate your on-premises workload requirements to the cloud. It also allows you to scale compute and storage resources independently, based upon your workload needs.

    The vCore-based model is available to SQL Database managed instance, single database and elastic pool deployment options and enables the use of Azure Hybrid Benefit for SQL Server for each of these options. Pricing within the vCore-based model is therefore available with and without the hybrid benefit:

    • Licence included: Excludes Azure Hybrid Benefit for SQL Server. This option is for customers who choose not to apply their existing SQL Server licences with Software Assurance to vCore-based SQL Database deployment options.
    • Base rate: Reduced price that includes Azure Hybrid Benefit for SQL Server. Customers can opt into this price by using their SQL Server licences with Software Assurance.
  • Moving to the vCore-based model is not required. The introduction of the vCore-based model to the Elastic Pool and Single Database deployment options reflects our commitment to customer choice and flexibility. If you want to continue using the DTU-based model, you do not need to take any action and your experience and billing will remain unchanged. The DTU-based model will remain a viable option for purchasing SQL Database resources, alongside the vCore-based model.

  • The DTU and vCore-based models will continue to exist side by side. We are launching the vCore-based model in response to customer requests for more transparency around their database resources and the ability to scale compute and storage separately. The vCore-based model also enables additional savings for customers with active Software Assurance through the Azure Hybrid Benefit for SQL Server.

  • The Database Transaction Unit (DTU) is based on a blended measure of CPU, memory, reads and writes. The DTU-based performance levels represent preconfigured bundles of resources to drive different levels of app performance. If you do not want to worry about the underlying resources and prefer the simplicity of a preconfigured bundle while paying a fixed amount each month, you may find the DTU-based model more suitable for your needs.

    If you need more insight into the underlying resources or need to scale them independently to achieve optimal performance, the vCore-based model will be the best choice. Additionally, if you have an active Software Assurance (SA) for SQL Server, you can leverage your existing investment and save up to 55% with Azure Hybrid Benefit for SQL Server. Both of the purchasing models provide the benefits of a fully managed service such as automated backups, software updates and patches.

  • The new service tiers offer a simple online conversion method that is similar to the existing process of upgrading databases from Standard to Premium service tier and vice versa. This conversion can be initiated using Portal, ARM, PowerShell, Azure CLI or T-SQL.

  • In the vCore-based model, the service is billed on a predictable, hourly rate based on the service tier, provisioned compute in vCores, provisioned storage in GB/month and consumed backup storage. If the backup exceeds the total database size (i.e. 100% of the database size), there will be additional charges. vCore hours, configured database storage, consumed IO and backup storage are clearly itemised in the bill, making it easier to see the details of resources you have used. Backup storage up to 100% of the maximum database size is included, beyond which you will be billed in GB/month consumed in a month.

    For example:

    • If the SQL database exists for 12 hours in a month, the bill will show usage for 12 hours of vCore. If the SQL database provisioned an additional 100 GB, the bill will show storage usage in units of GB/month prorated hourly and number of IOs consumed in a month.

    If the SQL database is active for less than one hour, you will be billed for each hour the database exists using the highest service tier selected, provisioned storage and IO that applied during that hour, regardless of usage or whether the database was active for less than an hour.

    For example:

    • If you create a Managed Instance and delete it five minutes later, you’ll be charged for one database hour.
    • If you create a Managed Instance in the General Purpose tier with 8 vCores, and then immediately upgrade it to 16 vCores, you’ll be charged at the 16 vCore rate for the first hour.

    Note: For a limited period until 30 June 2018, backup charges and IO charges will be free of charge.

  • Backup storage is associated with automated backups of your instance. Increasing your backup retention period increases the backup storage that’s consumed by your instance. There’s no additional charge for backup storage for up to 100 per cent of your total provisioned server storage. Additional consumption of backup storage will be charged in GB per month. For example, if you have the database storage size of 100 GB, you’ll get 100 GB of backup at no additional cost. But if the backup is 110 GB, you’ll pay for the additional 10 GB.

    Note: For a limited period, until 30 June 2018, the backup charges will be free.

  • There will be no additional charges for network data ingress or egress during public preview. Additional charges will be introduced at general availability.

  • Imagine that an S3 database has provisioned 1 TB. The amount of storage included for S3 is 250 GB, and so the extra storage amount is 1024 GB - 250 GB = 774 GB. The unit price for extra storage in the Standard tier is approximately $-/GB/month, and so the extra storage price is 774 GB * $-/GB/month = $-/month. Therefore, the total price for the S3 database is $-/month for DTUs + $-/month for extra storage = $-/month.
  • Suppose a 125 eDTU Premium pool has provisioned 1 TB. The amount of storage included for a 125 eDTU Premium pool is 250 GB, and so the extra storage amount is 1024 GB - 250 GB = 774 GB. The unit price for extra storage in the Premium tier is approximately $-/GB/month, and so the extra storage price is 774 GB * $-/GB/month = $-/month. Therefore, the total price for the pool is $-/month for pool eDTUs + $-/month for extra storage = $-/month.

Azure Hybrid Benefit for SQL Server

  • The Azure Hybrid Benefit for SQL Server helps you maximise the value from your current licensing investments and accelerate your migration to the cloud. Azure Hybrid Benefit for SQL Server is an Azure-based benefit that enables you to use your SQL Server licences with active Software Assurance to pay a reduced rate (“base rate”) on SQL Database. Azure Hybrid Benefit for SQL Server is available to all vCore-based options: SQL Database Managed Instance, Single Database and Elastic Pool. You can apply this benefit even if the SKU is active but note that the base rate will be applied from the time you select it in the portal. No credit will be issued retroactively.

    You can activate the Azure Hybrid Benefit via the Azure Portal by confirming that you have sufficient active licences with Software Assurance. The Azure Hybrid Benefit works as follows:

    • If you have Standard Edition per core licences with Software Assurance, you can get 1 vCore in the General Purpose option for every 1 licence core you own on-premises.
    • If you have Enterprise Edition per core licences with Software Assurance, you can get 1 vCore in the Business Critical option (coming soon) for every 1 licence core you own on-premises. Note: The Azure Hybrid Benefit for SQL Server for the Business Critical option is only available to Enterprise Edition customers.
    • If you have highly virtualised Enterprise Edition per core licences with Software Assurance, you can get 4 vCores in the General Purpose option for every 1 licence core you own on-premises. This is a unique virtualisation benefit available only on Azure.
  • The virtualisation benefit is applicable to virtualised workloads on vCore-based Azure SQL Database. You can use it to convert 1 licence core of SQL Enterprise Edition with active Software Assurance to get up to 4 vCores of General Purpose at the base rate. This makes moving virtualised apps to vCore-based SQL Database options highly cost-effective. For example, if you have 4 core licences of SQL Enterprise Edition, you can receive up to 16 vCores of General Purpose at the base rate.

  • Your licences must be used either on-premises or in the cloud. However, you have a 180-day grace period during which you can use licences both on-premises and in the cloud to facilitate migration.

  • No. Azure Hybrid Benefit cannot be applied retroactively.

  • To use Azure Hybrid Benefit for SQL Server, you need active Software Assurance. If your Software Assurance expires and you don’t renew it, you’ll be moved to the Licence Included pricing of the respective SKU.

Azure SQL Database reserved capacity

  • Azure SQL Database reserved capacity enables you to save up to 33%1 compared to licence-included pricing by pre-paying for your SQL Database compute capacity on a one- or three-year term. It is an expansion of Azure reservation pricing, which also includes Azure reserved VM instances.

    Today, customers with active Software Assurance can save up to 55% by using Azure Hybrid Benefit for SQL Server with the new vCore-based purchasing model in SQL Database. Now, with support for reserved capacity on single databases, elastic pools and managed instances, you can unlock even more savings when you combine your Azure Hybrid Benefit with reserved vCore pricing to achieve savings of up to 80%2. You can lower your total cost of ownership by combining reservation pricing with licence-included prices to manage costs across predictable and variable workloads and improve your budgeting and forecasting with a single upfront payment, making it easy to calculate your investments.

    1 Savings based on eight vCore SQL Database Managed Instance General Purpose in West2 US Region, running 730 hours per month. Savings are calculated from on-demand full price (license included) against 3-year reserved capacity Licence Included. Actual savings may vary based on region, instance size and performance tier. Prices as of May 2018, subject to change.

    2 Savings based on eight vCore SQL Database Managed Instance Business Critical in West2 US Region, running 730 hours per month. Savings are calculated from on-demand full price (licence included) against base rate with Azure Hybrid Benefit plus 3-year reserved capacity. Savings excludes Software Assurance cost for SQL Server Enterprise edition, which may vary based on EA agreement. Actual savings may vary based on region, instance size and performance tier. Prices as of May 2018, subject to change.

  • Azure SQL Database reserved capacity is available in all public Azure regions except UK North. If you already have vCore-based SQL deployments in UK North and would like to purchase reserved capacity for them, you can open a Help+Support request and we will unblock your subscription in that region. Reserved capacity is currently not available in sovereign clouds, which includes Azure Germany, Azure US Government and China.
  • You can purchase one-year or three-year term SQL Database reserved capacity with a single, upfront payment. Reservations are available for purchase through https://portal.azure.com. The reservations menu will appear on the left pane in the Azure portal.
  • SQL Database reserved capacity has a scope of either a Single subscription or Shared. This scope controls how many subscriptions can leverage the billing benefit associated with the reservation, and it controls how the reservation is applied to specific subscriptions. 

    A reservation scoped to a single subscription means that the reserved capacity discount will only apply to SQL Database resources within the selected subscription.  

    A reservation with the scope of Shared means that the billing benefit for it can be shared across any subscription in the enrolment (Enterprise Agreement customers) or account (Pay-as-you-go customers) except for MSDN subscriptions in the enrolment or non-Pay-as-you-go subscriptions in the account.

  • The reservation start and end dates are based on the purchase date and duration of the reservation. The benefit will immediately apply to any existing running deployments that match the terms of the reservation based on where the reservation is made available, i.e. scoped to a single subscription or shared across the entire Azure account/enrolment. Otherwise, the reservation benefit will apply when you have new deployments that match the terms of the reservation.
  • For EA customers, reserved capacity purchases will always be deducted from any available monetary commitment first; this deduction will happen in the month the reserved capacity was purchased. In the event that you do not have enough monetary commitment or do not have any monetary commitment, all reserved capacity purchases will show on your next overage invoice.

    For web direct customers, all reserved capacity charges will appear on the credit card on file or the next invoice if you have invoice terms established on your account.

  • You can view reserved capacity usage on the “Usage Summary” page under the “Reports” menu on the EA Portal (https://ea.azure.com). There, you will see a “Reservation” section that will show reserved capacity usage. In addition to this, you can find reserved capacity usage details in the detailed usage file (CSV) that you can download from the EA Portal (https://ea.azure.com). The “Additional Info” field will help you to identify the usage against reserved capacity.
  • Your deployments will continue running and will be billed at an on-demand rate once the reserved capacity benefit has expired. You will no longer receive the price benefit for reserved capacity.
  • Yes, you will receive email notifications at least 30 days prior to expiration. Additionally, you can view reservation details in the Azure portal.
See the SQL Database FAQs in the documentation.

Resources

Estimate your monthly costs for Azure services

Review Azure pricing frequently asked questions

Learn more about Azure SQL Database

Review technical tutorials, videos and more resources

Added to estimate. Press 'v' to view on calculator View on calculator

Learn and build with $200 in credit, and keep going for free