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.

  1. Managed Instance
  2. Elastic pool
  3. Single database

Single Database offers provisioned compute and serverless compute tier choices.

vCore

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.

Serverless compute (preview)

The SQL Database serverless compute tier optimises price-performance and simplifies performance management for single databases with intermittent, unpredictable usage by auto-scaling compute and billing for compute used per second. For details, see the FAQ section and documentation.

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

Minimum vCores Maximum vCores Minimum memory (GB) Maximum memory (GB) Price1
0.5 4 2.02 12 $-/vCore-second
($-/vCore-hour)

1The above price reflects a Preview discount.

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

Point-in-time restore

By default, seven days of database backups are stored in 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 size of the database and the rate of change. The storage amount up to 100 percent of database size is provided at no extra charge. Additional backup storage consumption will be charged in GB/month.

Price
RA-GRS $-/GB/month
ZRS $-/GB/month
LRS $-/GB/month

Long-term retention

Many applications have regulatory, compliance or other business purposes that require you to retain database backups for longer periods of time. By using the long-term retention (LTR) feature, you can store full backups for up to 10 years. You can then restore any backup as a new database.

Price
RA-GRS $-/GB/month
ZRS $-/GB/month
LRS $-/GB/month

Provisioned compute

The SQL Database provisioned compute tier provides a fixed amount of compute resource for a fixed price billed hourly. It optimises price performance for single databases and elastic pools with more regular usage that cannot afford any delay in compute warm-up after idle usage periods. For details, see the FAQ section and documentation.

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 $- $- $- $- $-
3 21 $- $- $- $- $-
4 28 $- $- $- $- $-
5 35 $- $- $- $- $-
6 42 $- $- $- $- $-
7 49 $- $- $- $- $-
8 56 $- $- $- $- $-
9 63 $- $- $- $- $-
10 70 $- $- $- $- $-
16 112 $- $- $- $- $-
24 157 $- $- $- $- $-

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

2Learn 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 10.2 $- $- $- $- $-
4 20.4 $- $- $- $- $-
6 30.6 $- $- $- $- $-
8 40.8 $- $- $- $- $-
10 51 $- $- $- $- $-
12 61.2 $- $- $- $- $-
14 71.4 $- $- $- $- $-
16 81.6 $- $- $- $- $-
18 91.8 $- $- $- $- $-
20 102 $- $- $- $- $-
24 122.4 $- $- $- $- $-
32 163.2 $- $- $- $- $-
40 204 $- $- $- $- $-
80 396 $- $- $- $- $-

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

2Learn 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

Point-in-time restore

By default, seven days of database backups are stored in 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 size of the database and the rate of change. The storage amount up to 100 percent of database size is provided at no extra charge. Additional backup storage consumption will be charged in GB/month.

Price
RA-GRS $-/GB/month
ZRS $-/GB/month
LRS $-/GB/month

Long-term retention

Many applications have regulatory, compliance or other business purposes that require you to retain database backups for longer periods of time. By using the long-term retention (LTR) feature, you can store full backups for up to 10 years. You can then restore any backup as a new database.

Price
RA-GRS $-/GB/month
ZRS $-/GB/month
LRS $-/GB/month

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 $- $- $- $- $-
3 21 $- $- $- $- $-
4 28 $- $- $- $- $-
5 35 $- $- $- $- $-
6 42 $- $- $- $- $-
7 49 $- $- $- $- $-
8 56 $- $- $- $- $-
9 63 $- $- $- $- $-
10 70 $- $- $- $- $-
16 112 $- $- $- $- $-
24 157 $- $- $- $- $-

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

2Learn 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 10.2 $- $- $- $- $-
4 20.4 $- $- $- $- $-
6 30.6 $- $- $- $- $-
8 40.8 $- $- $- $- $-
10 51 $- $- $- $- $-
12 61.2 $- $- $- $- $-
14 71.4 $- $- $- $- $-
16 81.6 $- $- $- $- $-
18 91.8 $- $- $- $- $-
20 102 $- $- $- $- $-
24 122.4 $- $- $- $- $-
32 163.2 $- $- $- $- $-
40 204 $- $- $- $- $-
80 396 $- $- $- $- $-

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

2Learn 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

Point-in-time restore

By default, seven days of database backups are stored in 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 size of the database and the rate of change. The storage amount up to 100 percent of database size is provided at no extra charge. Additional backup storage consumption will be charged in GB/month.

Price
RA-GRS $-/GB/month
ZRS $-/GB/month
LRS $-/GB/month

Long-term retention

Many applications have regulatory, compliance or other business purposes that require you to retain database backups for longer periods of time. By using the long-term retention (LTR) feature, you can store full backups for up to 10 years. You can then restore any backup as a new database.

Price
RA-GRS $-/GB/month
ZRS $-/GB/month
LRS $-/GB/month

Hyperscale

Hyperscale provides rapid, dynamic storage scaling up to 100 TB to help you optimise database resources for your workload’s needs. Each additional read replica 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 price1 Azure Hybrid Benefit2 Price (% Savings) 1-year reserved licence-included price (% savings)3 3-years reserved licence-included price (% savings)3 3 years reserved with Azure Hybrid Benefit (% savings)3
1 7 $- $- $- $- $-
2 14 $- $- $- $- $-
3 21 $- $- $- $- $-
4 28 $- $- $- $- $-
5 35 $- $- $- $- $-
6 42 $- $- $- $- $-
7 49 $- $- $- $- $-
8 56 $- $- $- $- $-
9 63 $- $- $- $- $-
10 70 $- $- $- $- $-
16 112 $- $- $- $- $-
24 157 $- $- $- $- $-

1The pricing above for Single Database Hyperscale reflects general availability and will be effective from 1 July 2019. Usage prior to 1 July 2019 will be billed at the preview rates.

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

3Learn 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 price1 Azure Hybrid Benefit2 Price (% Savings) 1-year reserved licence-included price (% savings)3 3-years reserved licence-included price (% savings)3 3 years reserved with Azure Hybrid Benefit (% savings)3
2 10.2 $- $- $- $- $-
4 20.4 $- $- $- $- $-
6 30.6 $- $- $- $- $-
8 40.8 $- $- $- $- $-
10 51 $- $- $- $- $-
12 61.2 $- $- $- $- $-
14 71.4 $- $- $- $- $-
16 81.6 $- $- $- $- $-
18 91.8 $- $- $- $- $-
20 102 $- $- $- $- $-
24 122.4 $- $- $- $- $-
32 163.2 $- $- $- $- $-
40 204 $- $- $- $- $-
80 396 $- $- $- $- $-

1The pricing above for Single Database Hyperscale reflects general availability and will be effective from 1 July 2019. Usage prior to 1 July 2019 will be billed at the preview rates.

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

3Learn 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 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.

Price
GB/month $-

Backup storage

Point-in-time restore

By default, seven days of database backups are stored in 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 size of the database and the rate of change. The storage amount up to 100 percent of database size is provided at no extra charge. Additional backup storage consumption will be charged in GB/month.

Price
RA-GRS $-/GB/month
ZRS $-/GB/month
LRS $-/GB/month

I/Os

I/O rate Preview Price
Every 1 million requests* $-
*As a limited-time promotion, I/Os will not be charged while Hyperscale is in Preview.

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 200 250 GB 1 TB $-
S6 400 250 GB 1 TB $-
S7 800 250 GB 1 TB $-
S9 1,600 250 GB 1 TB $-
S12 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.

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.

Long-term retention

Price
RA-GRS $-/GB/month
ZRS $-/GB/month
LRS $-/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

Dev/test pricing for SQL Database is billed at the same rate as Azure Hybrid Benefit pricing, with savings of up to 55% on Licence Included prices.

Dev/test 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.

    Azure Hybrid Benefit is not available in the serverless compute tier of SQL Database.

  • 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.
  • Increasing your backup retention period increases the backup storage that’s consumed by your instance.

    In the vCore-based model, 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.

    In the DTU-based model, the Backup Storage cost is included in the total price and the maximum retention period for a database depends on the service tier.

    See documentation to learn more about Backup Storage for Point-In-Time Restore.

  • In both the vCore-based and DTU-based models, consumption will be charged in GB per month.

    See documentation to learn more about Backup Storage for Long-term Retention.

  • 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 SQL Database pricing – Serverless

  • The key difference between the serverless and provisioned compute tiers is in the provisioning and billing of compute resources. In the serverless compute tier, compute resources scale dynamically up or down based on the workload’s requirements and are billed on a per-second basis, pausing during periods of inactivity. In the provisioned compute tier, a customer can purchase a certain amount of compute resources and will be billed for them on an hourly basis.

    The serverless compute tier is generally better suited for single databases with variable usage patterns interspersed with periods of inactivity, or databases with compute resource usage that is difficult to predict. These can benefit from savings due to per-second billing based on the amount of compute resources used.

    The provisioned compute tier is generally better suited for:

    • Single databases with more uniform and more substantial compute utilisation over time. Databases with this usage pattern are generally less expensive in the provisioned compute tier.
    • Multiple databases with varying and unpredictable compute usage that can be consolidated within an elastic pool for better price optimisation.
  • Serverless is offered on the vCore-based purchase model and the single database service tier.

  • The total bill is the summation of the compute bill and storage bill.

    Billing for compute is on a per-second rate based on actual usage of compute resources (for details, please see the next question: “How is the compute bill calculated in the serverless compute tier?”).

    Billing for storage within a given service tier is the same for both the serverless and provisioned compute tiers.

  • Compute is billed on a per-second rate based on actual usage subject to billing for minimum compute resources provisioned while the database is online.

    The amount of compute billed each second is based on the maximum of CPU and memory used each second. To compare CPU with memory for billing purposes, memory is normalised into units of vCores by rescaling the amount of memory in GB by 3 GB per vCore. If the amount of CPU and memory used is less than the minimum amount provisioned, then the provisioned amount will be billed. When the database has been paused, customers pay nothing for compute and only storage will be billed.

    Customers can configure the range of compute capacity available (min. vCores and max. vCores) for the database and the period of inactivity before a database is paused (auto-pause delay). See documentation for details.

    For example, let’s say that you configure min. vCores as 1, max. vCores as 4 and auto-pause delay as 6 hours. This configuration corresponds to a minimum memory of around 6 GB and a maximum memory of 12 GB. The below table represents your bill if usage varies as follows during a 12-hour period:

    Duration CPU used (vCores) Memory used (GB) Billed vCores Billed vCore-seconds
    1 minute (60 seconds) 1.5 3 1.5 (based on CPU used) 1 90
    1 minute (60 seconds) 4 9 4 (based on CPU used) 240
    1 minute (60 seconds) 0.5 12 4 (based on memory used) 240
    6 hours (21,600 seconds) 0 2 1 (based on minimum compute resources) 2 21,600
    5 hours 56 minutes (21,360 seconds) 0 0 0 (database will be paused after 6-hour auto-pause delay) 0
    1 minute (60 seconds) 0.5 9 3 (based on memory used) 180
    Total: 12 hours Total: 22,350

    1 CPU used (1.5 vCores) is greater than memory used after rescaling based on 3 GB per vCore (3 GB ÷ 3 vCores per GB = 1 vCore). Hence, 1.5 vCores are billed.

    2 CPU used (0 vCores) and memory used after rescaling based on 3 GB per vCore (2 GB ÷ 3 vCores per GB = 0.67 vCores) are both lower than the minimum compute resources (1 vCore). Hence, 1 vCore is billed.

    Total bill for compute during this 12-hour period will be $-.

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.

    Azure Hybrid Benefit is not available in the serverless compute tier of SQL Database.

  • 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 improve your budgeting and forecasting with a single upfront payment, making it easy to calculate your investments.

    Reserved capacity is not available in the serverless compute tier of SQL Database.

    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