Managed, intelligent SQL in the cloud
Part of the Azure SQL family of SQL database services, Azure SQL Database is the intelligent, scalable database service built for the cloud with AI-powered features that maintain peak performance and durability. Optimise costs without worrying about resource management with serverless compute and Hyperscale storage resources that automatically scale.
Explore pricing options
Apply filters to customize pricing options to your needs.
Prices are estimates only and are not intended as actual price quotes. Actual pricing may vary depending on the type of agreement entered with Microsoft, date of purchase, and the currency exchange rate. Prices are calculated based on US dollars and converted using London closing spot rates that are captured in the two business days prior to the last business day of the previous month end. If the two business days prior to the end of the month autumn on a bank holiday in major markets, the rate setting day is generally the day immediately preceding the two business days. This rate applies to all transactions during the forthcoming month. Sign in to the Azure pricing calculator to see pricing based on your current programme/offer with Microsoft. Contact an Azure sales specialist for more information on pricing or to request a price quote. See frequently asked questions about Azure pricing.
US government entities are eligible to purchase Azure Government services from a licensing solution provider with no upfront financial commitment or directly through a pay-as-you-go online subscription.
Important—The price in R$ is merely a reference; this is an international transaction and the final price is subject to exchange rates and the inclusion of IOF taxes. An eNF will not be issued.
US government entities are eligible to purchase Azure Government services from a licensing solution provider with no upfront financial commitment or directly through a pay-as-you-go online subscription.
Important—The price in R$ is merely a reference; this is an international transaction and the final price is subject to exchange rates and the inclusion of IOF taxes. An eNF will not be issued.
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
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.
General purpose
Ideal for most business workloads, offering balanced and scalable compute and storage options.
Standard-series (Gen 5)
Standard-series (Gen 5) logical CPUs are based on Intel E5-2673 v4 (Broadwell) 2.3 GHz, Intel SP8160 (Skylake), Intel Xeon Platinum 8272CL 2.5 GHz (Cascade Lake) and Intel(R) Xeon Scalable 2.8 GHz processor (Ice Lake) processors. In the standard-series (Gen 5), 1 vCore = 1 hyper thread. The standard-series (Gen 5) logical CPU is great for most relational database servers.
Minimum vCores | Maximum vCores | Minimum Memory (GB) | Maximum Memory (GB) | Price |
---|---|---|---|---|
0.5 | 80 | 2.02 | 240 |
$-/vCore-second ($-/vCore-hour) |
Locally Redundant Storage
In the general purpose tier, you are charged for Premium blob storage that you provision. Storage can be configured between 5 GB and 4 TB with 1 GB increments.
Storage | 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 retention period can be increased to up to 35 days. Any corrupted or deleted database can be restored to any point in time within that period. The storage is used by weekly full backups, daily differential backups and frequent transaction log backups in between. The backup cost depends on the size of the database, the rate of change and the configured retention period. The backup storage amount equal to the maximum data size is provided at no extra charge. Additional backup storage consumption will be charged in GB/month. Learn more about automated backups, and how to monitor and manage backup costs.
Redundancy | Price |
---|---|
LRS | $-/GB/month |
ZRS | $-/GB/month |
RA-GRS | $-/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. Learn more about long-term retention.
Redundancy | Price |
---|---|
LRS | $-/GB/month |
ZRS | $-/GB/month |
RA-GRS | $-/GB/month |
Hyperscale
Serverless Hyperscale combines the benefits of compute auto-scaling with storage auto-scaling up to 100 TB to help you optimise price-performance of your database resources to meet your workload's needs. If zone redundancy is enabled, the database must have at least one high availability (HA) replica. The pricing below is applicable for both primary and secondary (high availability and named) replicas. See the Azure Pricing Calculator for more information.
Standard-series (Gen 5)
Standard-series (Gen 5) logical CPUs are based on Intel E5-2673 v4 (Broadwell) 2.3 GHz, Intel SP8160 (Skylake), Intel Xeon Platinum 8272CL 2.5 GHz (Cascade Lake) and Intel(R) Xeon Scalable 2.8 GHz processor (Ice Lake) processors. In the standard-series (Gen 5), 1 vCore = 1 hyper thread. The standard-series (Gen 5) logical CPU is great for most relational database servers.
Minimum vCores | Maximum vCores | Minimum Memory (GB) | Maximum Memory (GB) | Price |
---|---|---|---|---|
0.5 | 80 | 2.05 | 240 |
$-/vCore-second ($-/vCore-hour) |
Storage
In the Hyperscale tier, you are charged for storage for your database based on actual allocation. Storage is dynamically allocated between 10 GB and 100 TB, in 10 GB increments.
Storage | Price |
---|---|
GB/month | $- |
Back up storage (point-in-time restore)
By default, seven days of backups are stored in RA-GRS Standard blob storage. Any corrupted or deleted database can be restored to any point in time within that period. The storage is used by periodic storage blob snapshots and all generated transaction log. The usage of the backup storage depends on the rate of change of the database and the configured retention period. Back up storage consumption will be charged in GB/month. Learn more about automated backups, and how to monitor and manage backup costs.
Redundancy | Price |
---|---|
LRS | $-/GB/month |
ZRS | $-/GB/month |
RA-GRS | $-/GB/month |
RA-GZRS | $-/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.
Standard-series (Gen 5)
Standard-series (Gen 5) logical CPUs are based on Intel E5-2673 v4 (Broadwell) 2.3 GHz, Intel SP8160 (Skylake), Intel Xeon Platinum 8272CL 2.5 GHz (Cascade Lake) and Intel(R) Xeon Scalable 2.8 GHz processor (Ice Lake) processors. In the standard-series (Gen 5), 1 vCore = 1 hyper thread. The standard-series (Gen 5) logical CPU is great for most relational database servers.
vCORE | Memory (GB) | Pay as you go | 1 year reserved capacity 2 | 3 year reserved capacity 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 | $- |
$-
|
$-
|
128 | 652 | $- |
$-
|
$-
|
1Applies to SQL Server Licenses 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.
DC-series
The DC-series logical CPUs are based on Intel XEON E-2288G processors with Software Guard Extensions (Intel SGX) technology. In the DC-series, 1 vCore = 1 physical core. DC-series supports Always Encrypted with secure enclaves and it is designed to for workloads that process sensitive data and demand confidential query processing capabilities.
vCORE | Memory (GB) | Pay as you go |
---|---|---|
2 | 9 | $- |
4 | 18 | $- |
6 | 27 | $- |
8 | 36 | $- |
10 | 45 | $- |
12 | 54 | $- |
14 | 63 | $- |
16 | 72 | $- |
18 | 81 | $- |
20 | 90 | $- |
32 | 144 | $- |
40 | 180 | $- |
Fsv2-series
The Fsv2-series logical CPUs are based on Intel Xeon® Platinum 8168 (SkyLake) processors. In Fsv2-series, 1 vCore = 1 hyper thread. Fsv2-series is optimised for workloads demanding more CPU performance per vCore.
vCORE | Memory (GB) | Pay as you go |
---|---|---|
8 | 15.1 | $- |
10 | 18.9 | $- |
12 | 22.7 | $- |
14 | 26.5 | $- |
16 | 30.2 | $- |
18 | 34 | $- |
20 | 37.8 | $- |
24 | 45.4 | $- |
32 | 60.5 | $- |
36 | 68 | $- |
72 | 136 | $- |
1Applies to SQL Server Licenses with active Software Assurance (SA). Learn more about Azure Hybrid benefit for SQL Server.
This hardware option is subject to regional availability. See our documentation for the latest list of available regions.
Compute is provisioned in virtual cores (vCores). A vCore represents a logical CPU offered with an option to choose between compute generations.
Locally Redundant Storage
In the general purpose tier, you are charged for Azure premium locally redundant storage that you provision. Storage can be configured between 5 GB and 4 TB with 1 GB increments. Locally Redundant Storage copies your data synchronously three times within a single physical location in the primary region.
Storage | 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 retention period can be increased to up to 35 days. Any corrupted or deleted database can be restored to any point in time within that period. The storage is used by weekly full backups, daily differential backups and frequent transaction log backups in between. The backup cost depends on the size of the database, the rate of change and the configured retention period. The backup storage amount equal to the maximum data size is provided at no extra charge. Additional backup storage consumption will be charged in GB/month. Learn more about automated backups, and how to monitor and manage backup costs.
Redundancy | Price |
---|---|
LRS | $-/GB/month |
ZRS | $-/GB/month |
RA-GRS | $-/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. Learn more about long-term retention.
Redundancy | Price |
---|---|
LRS | $-/GB/month |
ZRS | $-/GB/month |
RA-GRS | $-/GB/month |
Business critical
Business applications with high IO requirements. Offers highest resilience to failures using several isolated replicas. Because the zone-redundant configuration in the Premium or Business Critical service tiers does not create additional database redundancy, you can enable it at no extra cost.
Standard-series (Gen 5)
Standard-series (Gen 5) logical CPUs are based on Intel E5-2673 v4 (Broadwell) 2.3 GHz, Intel SP8160 (Skylake), Intel Xeon Platinum 8272CL 2.5 GHz (Cascade Lake) and Intel(R) Xeon Scalable 2.8 GHz processor (Ice Lake) processors. In the standard-series (Gen 5), 1 vCore = 1 hyper thread. The standard-series (Gen 5) logical CPU is great for most relational database servers.
vCORE | Memory (GB) | Pay as you go | 1 year reserved capacity 2 | 3 year reserved capacity 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 | $- |
$-
|
$-
|
128 | 652 | $- |
$-
|
$-
|
1Applies to SQL Server Licenses 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.
DC-series
The DC-series logical CPUs are based on Intel XEON E-2288G processors with Software Guard Extensions (Intel SGX) technology. In the DC-series, 1 vCore = 1 physical core. DC-series supports Always Encrypted with secure enclaves and it is designed to for workloads that process sensitive data and demand confidential query processing capabilities.
vCORE | Memory (GB) | Pay as you go |
---|---|---|
2 | 9 | $- |
4 | 18 | $- |
6 | 27 | $- |
8 | 36 | $- |
10 | 45 | $- |
12 | 54 | $- |
14 | 63 | $- |
16 | 72 | $- |
18 | 81 | $- |
20 | 90 | $- |
32 | 144 | $- |
40 | 180 | $- |
Storage
In the business critical tier, you are 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.
Storage | 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 retention period can be increased to up to 35 days. Any corrupted or deleted database can be restored to any point in time within that period. The storage is used by weekly full backups, daily differential backups and frequent transaction log backups in between. The backup cost depends on the size of the database, the rate of change and the configured retention period. The backup storage amount equal to the maximum data size is provided at no extra charge. Additional backup storage consumption will be charged in GB/month. Learn more about automated backups, and how to monitor and manage backup costs.
Redundancy | Price |
---|---|
LRS | $-/GB/month |
ZRS | $-/GB/month |
RA-GRS | $-/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. Learn more about long-term retention.
Redundancy | Price |
---|---|
LRS | $-/GB/month |
ZRS | $-/GB/month |
RA-GRS | $-/GB/month |
Hyperscale
Build new, highly scalable cloud applications on Azure SQL Database Hyperscale. Hyperscale provides rapid, auto-scaling storage up to 100 TB to help you optimise database resources for your workload's needs. To enable zone redundancy, the database must have at least one secondary high availability replica. The pricing below is applicable for both primary and secondary (high availability and named) replicas. See the Azure Pricing Calculator for more information.
Standard-series (Gen 5)
Standard-series (Gen 5) logical CPUs are based on Intel E5-2673 v4 (Broadwell) 2.3 GHz, Intel SP8160 (Skylake), Intel Xeon Platinum 8272CL 2.5 GHz (Cascade Lake) and Intel(R) Xeon Scalable 2.8 GHz processor (Ice Lake) processors. In the standard-series (Gen 5), 1 vCore = 1 hyper thread. The standard-series (Gen 5) logical CPU is great for most relational database servers.
vCORE | Memory (GB) | Pay as you go | 1 year reserved capacity 1 | 3 year reserved capacity 1 |
---|---|---|---|---|
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 | $- |
$-
|
$-
|
1Learn 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.
DC-series
The DC-series logical CPUs are based on Intel XEON E-2288G processors with Software Guard Extensions (Intel SGX) technology. In the DC-series, 1 vCore = 1 physical core. DC-series supports Always Encrypted with secure enclaves and it is designed to for workloads that process sensitive data and demand confidential query processing capabilities.
vCORE | Memory (GB) | Pay as you go |
---|---|---|
2 | 9 | $- |
4 | 18 | $- |
6 | 27 | $- |
8 | 36 | $- |
10 | 45 | $- |
12 | 54 | $- |
14 | 63 | $- |
16 | 72 | $- |
18 | 81 | $- |
20 | 90 | $- |
32 | 144 | $- |
40 | 180 | $- |
Premium-series
Premium-series logical CPUs are based on the latest Intel(R) Xeon (Ice Lake) and AMD EPYCTM 7763v (Milan) chipsets, 1 vCore = 1 hyper thread. The premium-series logical CPU is a great fit for database workloads that require faster compute and memory performance as well as improved IO and network experience over the standard-series hardware offering.
vCORE | Memory (GB) | Pay as you go | 1 year reserved capacity 1 | 3 year reserved capacity 1 |
---|---|---|---|---|
2 | 10.4 | $- |
$-
|
$-
|
4 | 20.8 | $- |
$-
|
$-
|
6 | 31.1 | $- |
$-
|
$-
|
8 | 41.5 | $- |
$-
|
$-
|
10 | 51.9 | $- |
$-
|
$-
|
12 | 62.3 | $- |
$-
|
$-
|
14 | 72.7 | $- |
$-
|
$-
|
16 | 83 | $- |
$-
|
$-
|
18 | 93.4 | $- |
$-
|
$-
|
20 | 103.8 | $- |
$-
|
$-
|
24 | 124.6 | $- |
$-
|
$-
|
32 | 166.1 | $- |
$-
|
$-
|
40 | 207.6 | $- |
$-
|
$-
|
64 | 332.2 | $- |
$-
|
$-
|
80 | 415.2 | $- |
$-
|
$-
|
128 | 647.8 | $- |
$-
|
$-
|
1Learn more about Azure reservations and Azure SQL Database reserved capacity pricing.
Compute is provisioned in virtual cores (vCores). A vCore represents a logical CPU offered with an option to choose between compute generations.
Premium-series, memory-optimised
Premium-series memory-optimised logical CPUs are based on the latest Intel(R) Xeon (Ice Lake) and AMD EPYCTM 7763v (Milan) chipsets, 1 vCore = 1 hyper thread. This memory-optimised version provides nearly twice the memory per vCore and is great for database workloads that require improved memory performance over the standard-series.
vCORE | Memory (GB) | Pay as you go | 1 year reserved capacity 1 | 3 year reserved capacity 1 |
---|---|---|---|---|
2 | 20.8 | $- |
$-
|
$-
|
4 | 41.5 | $- |
$-
|
$-
|
6 | 62.3 | $- |
$-
|
$-
|
8 | 83 | $- |
$-
|
$-
|
10 | 103.8 | $- |
$-
|
$-
|
12 | 124.6 | $- |
$-
|
$-
|
14 | 145.3 | $- |
$-
|
$-
|
16 | 166.1 | $- |
$-
|
$-
|
18 | 186.9 | $- |
$-
|
$-
|
20 | 207.6 | $- |
$-
|
$-
|
24 | 249.1 | $- |
$-
|
$-
|
32 | 332.2 | $- |
$-
|
$-
|
40 | 415.2 | $- |
$-
|
$-
|
64 | 664.4 | $- |
$-
|
$-
|
80 | 830.5 | $- |
$-
|
$-
|
1Learn more about Azure reservations and Azure SQL Database reserved capacity pricing.
Compute is provisioned in virtual cores (vCores). A vCore represents a logical CPU offered with an option to choose between compute generations.
Storage
In the Hyperscale tier, you are charged for storage for your database based on actual allocation. Storage is dynamically allocated between 10 GB and 100 TB, in 10 GB increments.
Storage | 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 retention period can be increased to up to 35 days. Any corrupted or deleted database can be restored to any point in time within that period. The storage is used by weekly full backups, daily differential backups, and frequent transaction log backups in between. The backup cost depends on the size of the database, the rate of change and the configured retention period. The backup storage amount equal to the database size is provided at no extra charge. Additional backup storage consumption will be charged in GB/month. Learn more about automated backups, and how to monitor and manage backup costs.
Redundancy | Price |
---|---|
LRS | $-/GB/month |
ZRS | $-/GB/month |
RA-GRS* | $-/GB/month |
RA-GZRS* | $-/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. Learn more about long-term retention.
Redundancy | Price |
---|---|
LRS | $-/GB/month |
ZRS | $-/GB/month |
RA-GRS | $-/GB/month |
RA-GZRS | $-/GB/month |
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 detail.
Create a database now.
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 | $- |
Azure SQL Database (with the exception of serverless) is billed on a predictable, hourly rate. If the SQL database is active for less than one hour, it will be billed for each hour the database.
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 percent 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 | $- |
Note: Outbound data transfers are charged at regular data transfer rates.
Extra Data Storage
Service tier | Price |
---|---|
Standard | $-/GB/month |
Premium | $-/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. Learn more about long-term retention.
Storage | Price |
---|---|
RA-GRS | $-/GB/month |
Elastic jobs
Elastic jobs saves you time by providing the ability to create and schedule tasks to automatically perform across one or a group of databases, using job agents. You define and maintain the Transact-SQL scripts and elastic jobs performs tasks like deploying schema changes, collecting tenant telemetry and gathering query performance results.
Refreshed for modern applications, elastic jobs now provides enhanced portal support, Azure Alerts and more.
Service Tier* | Price |
---|---|
JA100 | $- |
JA200 | $- |
JA400 | $- |
JA800 | $- |
*Service tier is based upon the number of concurrent job targets.
Active geo-replication
Active geo-replication is a feature in SQL Database that lets you create a continuously synchronised readable geo-secondary database for a primary database. Both primary and geo-secondary are required to have the same service tier and it is also strongly recommended that the geo-secondary is configured with the same back up storage redundancy and compute size (DTUs or vCores) as the primary. Each geo-secondary is billed at the same price as a primary database with the same configuration. Backups are always taken on the primary database. If the secondary is configured with a different back up storage redundancy, then after a geo-failover, when the geo-secondary is promoted to the primary, new backups will be stored and billed according to the type of storage (RA-GRS, ZRS, LRS) selected on the new primary (previous secondary).
Each geo-secondary can be a single database or a database in an elastic pool. The databases in an elastic pool are on a single server and share a set number of resources at a set price, with billing occurring at the elastic pool level. Customers can add any number of secondaries to a pool, up to the maximum, without incurring additional charges.