Azure SQL Database

使用雲端中受控的智慧型 SQL,建置可隨著您業務步調調整規模的應用程式

在完全受控的 SQL 資料庫上更快建置下一個應用程式

Part of the Azure SQL family, Azure SQL Database is an intelligent, scalable, relational database service built for the cloud. Optimize performance and durability with automated, AI-powered features that are always up to date. With serverless compute and Hyperscale storage options that automatically scale resources on demand, you’re free to focus on building new applications without worrying about storage size or resource management.

完全受控的 SQL 資料庫會自動更新、佈建並備份,以便您專注於應用程式開發

Flexible and responsive serverless compute and Hyperscale storage rapidly adapt to your changing requirements

Layers of protection, built-in controls, and intelligent threat detection keep your data secure

Built-in AI and built-in high availability maintain peak performance and durability with an SLA of up to 99.995 percent

完全受控且永遠使用最新版 SQL

Eliminate the complexity of configuring and managing high availability, tuning, backups, and other database tasks with a fully managed SQL database.

Accelerate your application development in the only cloud with evergreen SQL using the latest SQL Server capabilities, and never worry about updates, upgrades, or end of support again.

深入了解

超大規模地調整需求量最大的工作負載

Break through the resource limitations that can affect your application’s performance. Azure SQL Database Hyperscale adapts to changing requirements by rapidly scaling storage up to 100 TB. Flexible, cloud-native architecture allows storage to grow as needed and enables you to back up data almost instantaneously and restore your database in minutes—regardless of the size of the data operation.

深入了解可調整性

利用可自動調整規模的計算將成本最佳化

Build modern apps your way with provisioned and serverless compute options. Azure SQL Database serverless simplifies performance management and helps developers focus on building apps faster and more efficiently with compute resources that automatically scale based on workload demand.

SQL Database serverless is best for scenarios where usage is intermittent and unpredictable and you only pay for compute resources you use on a per-second basis, which optimizes overall price performance.

下載資訊圖

觀看網路研討會

透過最佳擁有權總成本節省費用

Switch to Azure SQL Database and get better price performance than with other cloud providers. Azure SQL Database meets your mission-critical requirements and costs up to 86 percent less than the competition.1

Use Azure Hybrid Benefit for SQL Server to maximize the value from your current licensing investments. Use your SQL Server licenses with Software Assurance and save up to 55 percent compared to pay-as-you-go pricing on SQL Database.2

更快建置及傳遞現代化的智慧型應用程式

  • 在 Windows、Linux 和 Mac 這些熱門的平台上,使用 Visual Studio 和 Azure Data Studio 等熟悉的工具進行開發。
  • Build intelligent applications faster using popular languages such as .NET, Java, Node.js, Ruby, PHP, and Python.
  • Implement CI/CD Pipelines with Azure DevOps or GitHub.
  • Manage and scale your entire application and data stack using Azure App Service.
  • 簡化 .NET 應用程式與 SQL Database 和 App Service 原生支援的整合。

將您的 .NET 應用程式和資料一起移轉

進階資料安全性

  • Enable tamper-evident, cryptographic verification for your centralized data stores from within your database with SQL Database ledger. No data migration or application changes required.
  • Remediate potential threats in real time with intelligent threat protection and proactive vulnerability assessment alerts.
  • Get industry-leading, multi-layered protection with built-in security controls including network security, encryption, and access and key management.
  • Take advantage of the most comprehensive compliance coverage of any cloud database service.
  • Protect your data with Always Encrypted technology, where encryption keys are never revealed to the database engine.
  • 下載安全性資訊圖

智慧型關聯式雲端資料庫服務的定價

探索所有 SQL Database 定價選項,並找出符合您工作負載的效能。

受到各種規模公司的信任

降低成本並為客戶提供適當的效能

要快速調整規模,以應付大量使用者帶來的暴增需求,相當具有挑戰性。了解 Icertis 如何透過 Azure SQL Database 無伺服器降低成本,並協助客戶在需要效能時,獲得適當的效能層級。

ICERTIS

除去企業發展的瓶頸

了解 Paychex 如何移轉至 Azure SQL Database 以因應公司爆炸性的成長。Paychex 使用彈性集區大規模提供應用程式,兼具高效能和可用性,同時保有最佳成本效益。

Paychex

Boosting efficiency and scaling for growth

Learn how Axpo is using SQL Database serverless and Azure Machine Learning to evaluate the status and performance of its hydro plant equipment in real time.

Axpo

利用超大規模資料庫提升成長和創新能力

ClearSale 的內部部署平台發展快速,因此移轉到 SQL Database 超大規模資料庫。了解他們現在如何能夠每分鐘處理幾乎無限筆交易,並自動調整以因應其成長。

ClearSale

Unlocking new scale and efficiency

Learn how Schneider Electric consolidated 1,500 virtual machines (VMs), databases, and reporting apps into a single Hyperscale database with the power to scale with the company’s needs.

Schneider Electric

提高生產力並降低營運成本

了解 Thomson Reuters Elite 如何利用 Azure SQL Database,大幅加快上市速度,並降低內部部署實作的成本。

Thomson Reuters

Documentation, learning, and migration resources

移轉至 SQL Database

Get started right away with the Azure Migration Center.

文件

Explore tutorials, samples, and other documentation to learn how to use SQL Database.

Microsoft Learn

Expand your knowledge and earn certifications with hands-on online courses.

Azure SQL Database 更新、部落格及公告

  • Azure SQL Database provides the following deployment options for an Azure SQL database:

    • As a single database with its own set of resources managed via a logical server.
    • 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, where there is one database per customer or tenant. Purchasing individual databases and over provisioning to meet the variable and peak demand for each database is often not cost efficient, but with pools, you manage the collective performance and the databases scale up and down automatically. Our intelligent engine recommends a pool for databases when a usage pattern warrants it. For details, see elastic pool guidance.

  • The Azure Hybrid Benefit for SQL Server helps you maximize 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 licenses with active Software Assurance to pay a reduced rate (“base rate”) on vCore-based Azure SQL Database and Azure SQL Managed Instance. You may apply this benefit even if the SKU is active but note 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 attesting you have sufficient active licenses with Software Assurance.

    The Azure Hybrid Benefit for SQL Server provides:

    • The ability to move your licenses to a fully managed platform-as-a-service (PaaS) product. Azure is the only cloud that provides this ability. Amazon Web Services Relational Database Service (RDS) is not eligible for bring-your-own-license (BYOL) and must be offered as "license-included."
    • Four cores in the cloud for every one core on-premises for Enterprise edition customers in the general purpose or Hyperscale service tiers.
    • 180 days of dual-use rights to apply to current deployment (on premises or on third-party cloud) and in Azure to allow for data migration.
  • No. Azure SQL Database is a fully managed database service, which means that Microsoft operates SQL Server for you and ensures its availability and performance. SQL Database also includes innovative features to enhance your business continuity, such as built-in high availability. A comprehensive security portfolio allows you to implement intelligent features like threat detection, so that don’t have to worry about administering or maintaining hundreds or thousands of your SQL Server databases. View the full feature comparison of Azure SQL Database and SQL Server.
  • 以虛擬核心為基礎的服務層級主要依可用性、儲存體類型和 IOPS 來區分:

    一般用途提供一組預算導向且平衡的計算和儲存體選項,其中不會優先考慮 I/O 效能或容錯移轉時間。

    超大規模資料庫適用於大部分商務工作負載,已針對線上交易處理 (OLTP) 和混合式交易分析工作負載 (HTAP) 進行最佳化,並具備高調整性儲存體大小、讀取縮放,以及快速資料庫還原功能。

    「商務關鍵性」最適合需要高交易率且低 IO 延遲的 OLTP 應用程式。它使用多個已同步更新的複本,來提供最高的失敗復原力及快速容錯移轉。

  • Connectivity between your Microsoft Azure SQL Database and the Azure Internet gateway is guaranteed at least 99.99 percent of the time, regardless of your service tier. 0.01 percent is reserved for patches, upgrades, and failovers. For more information, read the SLA. For information about the availability architecture of Azure SQL Database, see high availability and Azure SQL Database.

準備就緒 - 讓我們設定 Azure 免費帳戶。

1價格效能比宣告的來源為 Microsoft 委託 GigaOm 於 2019 年 8 月執行之研究中的資料。該研究比較了單一 80 v 核心、Gen 5 Azure SQL Database 在商務關鍵性服務層級上,以及 Amazon Web Services Relational Database Service (AWS RDS) db.r4.16x 大型供應項目在 SQL Server 上的價格效能比。基準資料的來源為衍生自業界標準 TPC Benchmark™ E (TPC-E) 的 GigaOm Analytic Field Test,並以會模擬複雜 OLTP 應用程式中活動的唯讀和更新量大的交易混合為基礎。GigaOm 計算的價格效能比,是持續執行雲端平台三年的成本除以每秒輸送量交易。價格的根據為 2019 年 8 月公開推出的美國東部 Azure SQL Database 美金定價和美國東部 (俄亥俄州) AWS RDS 美金定價。價格效能比結果的根據為 GigaOm Analytic Field Test 中詳述的設定。實際結果和價格可能因為設定和區域而有所不同。

2節費的計算方式以美國東部區域 8 個 vCore 業務關鍵受控執行個體,每個月執行 730 小時計算。節省費用的計算方式,是以全額定價 (包含授權) 與基本費率 (套用適用於 SQL Server 的 Azure Hybrid Benefit) 相較,不含適用於 SQL Server Enterprise Edition 的軟體保證費用,該費用會因 Enterprise 合約而有所不同。實際節省的金額,會依各區域、執行個體大小和效能層級而有所不同。價格以 2020 年 2 月的價格為準,可能會有更動。