[go: up one dir, main page]

Trace Id is missing
Skip to main content
Azure
An image with blue and pink combination

Azure SQL Database

Build limitless, trusted, AI-ready apps on a fully managed SQL database
Overview

Build on fast, flexible, and elastic SQL

  • Build new apps with flexible Hyperscale cloud databases that automatically scale with the pace of your business.
  • Accelerate time to market on a managed service that supports multiple data formats, platforms, and popular languages.
    An isometric image of a clock, tools, and a computer and tablet or phone
  • Power your resource-intensive apps and keep mission-critical workloads running at peak performance.
  • Protect your data and maintain business continuity with built-in controls and machine learning–based security capabilities.
    An isometric view of a SQL database connecting to external systems or computers.
FEATURES

Build scalable and secure apps

Hyperscale

Rapidly scale up to meet demand and offload read workloads with scale-out support for up to 30 named replicas.

Microsoft Copilot in Azure

Experience AI-assistance in the design, operation, and optimization of your SQL applications.

AI-ready

Build intelligent applications using your SQL data with Azure OpenAI, Azure AI Search, and native vector search support.

Mirroring

Query and analyze your data like its local with near real-time SQL data replication into Microsoft Fabric.

Azure data platform connection

Easily connect to other Azure services such as Azure Functions without writing your own code.

Data API builder

Turn database objects into REST and GraphQL APIs and access data on any platform, language, or device.

Dev container templates

Simplify the development process and start coding immediately with preconfigured environments locally or in the cloud.

Intelligent query processing

Improve the query performance of existing workloads with minimal effort.

Security and governance

Protect your data with a multilayered approach to security that includes Microsoft Defender for SQL.
Security

Built-in security and compliance 

Microsoft has committed to investing $20 billion in cybersecurity over five years.
We employ more than 8,500 security and threat intelligence experts across 77 countries.
Azure has one of the largest compliance certification portfolios in the industry.
A woman in a denim jacket is using a tablet in a clothing store.
PRICING

Pricing for the intelligent, relational cloud database service

Explore pricing options and find the performance tier that best fits your workload.

Compare Azure SQL Database price performance

Azure SQL Database Hyperscale outpaces Amazon Aurora PostgreSQL by up to 68% in performance and value.1
CUSTOMER STORIES

See how customers are innovating with Azure SQL Database

 Try Azure SQL Database free of charge

Get 100,000 vCore seconds of serverless compute and 32 GB of storage every month for the life of your subscription.
FAQ

Frequently Asked Questions

  • Azure SQL Database is available as a single database with its own set of resources managed via a logical server, and as a pooled database in an elastic pool with a shared set of resources managed through a logical server. In general, elastic pools are designed for a typical software-as-a-service (SaaS) application pattern, with one database per customer or tenant. With pools, you manage the collective performance, and the databases scale automatically.

    Learn more about elastic pools. Learn more about software as a service (SaaS) application pattern.
  • Azure Hybrid Benefit helps you reduce the costs of your infrastructure and accelerates the migration to the cloud. Azure Hybrid Benefit for SQL Server is an Azure offer that enable you to pay a reduced rate ("base rate") for your SQL Server licenses with active Software Assurance on vCore-based Azure SQL Services. Further optimize your costs with centralized management of your Azure Hybrid Benefit across your entire subscription or billing account.

    Learn more about Azure Hybrid Benefit. Learn more about centralized management.
  • No. Azure SQL Database is a fully managed database service—Microsoft operates SQL Server for you and ensures its availability and performance. SQL Database also includes features to enhance your business continuity and security, such as built-in high availability and threat detection, so that you don't have to worry about administering or maintaining your SQL Server databases.

    Learn more about built-in high availability. Learn more about threat detection.
  • The vCore-based service tiers are primarily differentiated by availability, storage type, and input/output (I/O) per second. General purpose is a budget-oriented option that's best when input/output performance or failover time is not the priority. Hyperscale is optimized for online transaction processing (OLTP) and hybrid transactional analytical workloads. The business critical tier is best for OLTP applications with high transaction rates and low I/O latency requirements.
    Learn more about vCore-based service tiers.
  • Connectivity between Azure SQL Database and the Azure internet gateway is guaranteed at least 99.995 percent of the time for zone-redundant deployments, regardless of your service tier. For more information, read the SLA and learn about the high-availability architecture.
    Learn more about the SLA. Learn more about the high-availability architecture.
  • SQL databases, also known as relational databases, are systems that store collections of tables and organize structured sets of data in a tabular columns-and-rows format, similar to that of a spreadsheet.

    Learn more about SQL databases.
Next steps

Choose the Azure account that’s right for you

Pay as you go or try Azure free for up to 30 days.
Azure Solutions

Azure cloud solutions

Solve your business problems with proven combinations of Azure cloud services, as well as sample architectures and documentation.
Business Solution Hub

Find the right Microsoft Cloud solution

Browse the Microsoft Business Solutions Hub to find the products and solutions that can help your organization reach its goals.
  • [1] Price-performance claims based on data from a study commissioned by Microsoft and conducted by Principled Technologies in December 2023. The study compared performance and price performance between a 16 vCore and 32 vCore Azure SQL Database using premium-series hardware on the Hyperscale service tier and the db.r6i.4xlarge and db.r6i.8xlarge offerings for Amazon Aurora PostgreSQL I/O-Optimized (“Amazon Aurora”). Benchmark data is taken from a Principled Technologies report which used the HammerDB TPROC-C benchmark. The TPROC-C workload is derived from the TPC-C Benchmark and results were obtained with the HammerDB TPROC-C workload. The HammerDB TPROC-C workload is derived from the TPC-C benchmark and is not comparable to published TPC-C Benchmark results, as this implementation does not comply with all requirements of the TPC Benchmark. Price-performance is calculated by Principled Technologies as the cost of running the cloud platform continuously divided by new orders per minute throughput, based upon the standard. Prices are based on publicly available US pricing in East US 1 for Azure SQL Database and US East for Amazon Aurora as of December 2023. Performance and price-performance results are based upon the configurations detailed in the Principled Technologies report.  Actual results and prices may vary based on configuration and region.
#chatEngagement { color: #fff; background-color: #006abb; border: 1px solid #0078d4; border-radius: 4px; display: inline-block; font-size: 14px; font-weight: 600; padding: 10px 16px; } #chatEngagement:hover, #chatEngagement:active { text-decoration: underline; } #chatDisengagement { color: #0062ad; display: inline-block; font-size: 14px; font-weight: 600; padding-right: 1em; position: relative; text-decoration: none; border: none; background-color: transparent; } #chatEngagement:focus { outline: 1px solid #fff; outline-offset: -4px; text-decoration: underline; } #chatDisengagement:after { background-image: url("data:image/svg+xml,%3Csvg viewBox='0 0 12 12' fill='none' xmlns='http://www.w3.org/2000/svg'%3E%3Cpath d='M4 1L9 6L4 11' stroke='%230062ad'/%3E%3C/svg%3E"); content: ' '; height: 12px; width: 12px; display: inline-flex; vertical-align: middle; margin-left: .2em; transition: all .2s ease-in-out; position: absolute; bottom: -6px; background-color: transparent; } #chatDisengagement:focus { outline-offset: 10px; } #lp-iframe-container { border: 0; bottom: 0; box-shadow: 0 5px 15px 0 #00000033; height: 500px; left: auto !important; min-width: 300px; max-width: 350px; padding: 0; position: fixed; right: 0; top: auto !important; z-index: 1031; } #iFrame { height: 100%; width: 100%; border: 0; } #proactive-chat-dialog { position: fixed; z-index: 10400; bottom: -24px; right: 11px; } #proactive-chat-dialog .chatContainer { min-width: 272px; height: 277px; color: #000; line-height: 0; position: relative; border: 0 !important; background-repeat: no-repeat !important; background-color: #fff !important; margin: auto; padding: 12px; background-size: contain !important; box-shadow: 0 2.8px 2.2px rgba(0, 0, 0, 0.034), 0 6.7px 5.3px rgba(0, 0, 0, 0.048), 0 12.5px 10px rgba(0, 0, 0, 0.06), 0 22.3px 17.9px rgba(0, 0, 0, 0.072), 0 41.8px 33.4px rgba(0, 0, 0, 0.086), 0 100px 80px rgba(0, 0, 0, 0.12); } #proactive-chat-dialog .chatContainer .chat-cta { text-align: center; font-size: 24px; font-weight: 600; position: relative; top: 160px; } #proactive-chat-dialog .chatContainer .chat-buttons { position: relative; top: 185px; width: 100%; display: flex; gap: 1em; justify-content: center; flex-direction: column; } #proactive-chat-dialog .chatContainer .chat-buttons .arrow-link { width: auto; margin: auto; } #proactive-chat-dialog .chatContainer .chat-buttons .arrow-link:after { bottom: -6px; } @media only screen and (min-width: 33.75em) { #proactive-chat-dialog .chatContainer .chat-buttons { top: 200px; flex-direction: row; } } </style> <div id="proactive-chat-dialog" class="proactive-chat-hidden"> <div class="chatContainer" style="background: url('{{module.bg-img-src}}') no-repeat top left" > <div class="chat-cta">{{module.heading}}</div> <div class="chat-buttons"> <button type="button" id="chatEngagement" aria-label="{{chat-engagement.aria-label}}" class="button button--primary01 lp-chatnow" data-lp-event="click" data-bi-id="expand-chat" data-bi-an="chat" data-bi-chtid="azure chat 1" data-bi-chtnm="live person proactive chat" data-bi-bhvr="16" data-bi-tn="button button--primary01 lp-chatnow" > {{chat-engagement.btn-txt}} </button> <button type="button" id="chatDisengagement" aria-label="{{chat-disengagement.aria-label}}" class="arrow-link lp-nothanks" data-lp-event="close" data-bi-id="collapse-chat" data-bi-an="chat" data-bi-chtid="azure chat 1" data-bi-chtnm="live person proactive chat" data-bi-tn="arrow-link lp-nothanks" > {{chat-disengagement.btn-txt}} </button> </div> </div> </div> '/>
AI-powered assistant