什麼是 Azure SQL Database 服務What is Azure SQL Database service

Azure SQL Database 是一般用途的關聯式資料庫受控服務,可讓您建立高可用性和高效能資料儲存層,應用程式和 Microsoft Azure 雲端中的解決方案。Azure SQL Database is a general-purpose relational database managed service that enables you to create highly-available and high-performance data storage layer for the applications and solutions in Microsoft Azure cloud. SQL Database 可以是各種現代化雲端應用程式的最佳選擇,因為它可讓您使用功能強大的功能來處理這兩個關聯式資料及非關聯式結構例如圖形、 JSON、 空間和 XML。SQL Database can be the right choice for a variety of modern cloud applications because it enables you to use powerful functionalities for processing both relational data and non-relational structures such as graphs, JSON, spatial, and XML. 它根據最新穩定版本Microsoft SQL Server 資料庫引擎,並可讓您可以使用豐富的進階的查詢處理功能,例如高效能記憶體中技術智慧型查詢處理It is based on the latest stable version of the Microsoft SQL Server database engine and enables you to use rich set of advanced query processing features such as high performance in-memory technologies and Intelligent query processing. 依據 Microsoft 的雲端優先策略,SQL Server 的最新功能會先在 SQL Database 中發行,然後在 SQL Server 本身發行。With Microsoft's cloud-first strategy, the newest capabilities of SQL Server are released first to SQL Database, and then to SQL Server itself. 這種方法可為您提供最新的 SQL Server 功能,但沒有修補或升級的額外負荷,而這些新功能已在數百萬個資料庫上進行測試。This approach provides you with the newest SQL Server capabilities with no overhead for patching or upgrading - and with these new features tested across millions of databases. SQL Database 可讓您輕鬆地定義,並調整效能,在兩種不同的購買模型:虛擬核心為基礎的購買模型以 DTU 為基礎的購買模型SQL Database enables you to easily define and scale performance within two different purchasing models: a vCore-based purchasing model and a DTU-based purchasing model. SQL Database 是完全受控的服務具有內建的高可用性、 備份和其他常見的維護作業。SQL Database is fully-managed service that has built-in high-availablility, backups, and other common maintenance operations. Microsoft 會處理所有的修補和順暢地更新 SQL 和 OS 的程式碼,並抽走基礎結構的所有管理。Microsoft handles all patching and updating of the SQL and OS code seamlessly and abstracts away all management of the underlying infrastructure.

注意

如需 Azure SQL Database 的詞彙解釋,請參閱 SQL 資料庫術語詞彙For a glossary of terms in Azure SQL Database, see SQL Database terms glossary

Azure SQL Database 為 Azure SQL 資料庫提供下列部署選項:Azure SQL Database provides the following deployment options for an Azure SQL database:

deployment-options

  • 單一資料庫代表受到完整管理的隔離的資料庫是現代化的雲端應用程式的最佳選擇,以及需要單一可靠的資料來源的微服務。Single database represents fully-managed isolated database that is perfect choice for the modern cloud applications and microservices that need a single reliable data source. 單一資料庫是類似自主資料庫Microsoft SQL Server 資料庫引擎A single database is similar to a contained databases in Microsoft SQL Server database engine.
  • 受控執行個體是受到完整管理執行個體的Microsoft SQL Server 資料庫引擎包含一組可一起使用的資料庫。Managed instance is a fully-managed instance of the Microsoft SQL Server database engine containing a set of databases that can be used together. 它是最佳選擇,輕鬆移轉至 Azure 雲端的內部部署 SQL Server 資料庫以及需要利用 SQL Server Database Engine 提供功能強大的資料庫功能的應用程式。It is a perfect choice for easy migration of on-premises SQL Server databases to Azure cloud and for applications that need to leverage powerful database features that SQL Server Database Engine provides.
  • 彈性集區是一堆單一資料庫具有一組共用資源,例如 CPU 或記憶體。Elastic pool is a collection of Single databases with a shared set of resources such as CPU or memory. 單一資料庫可以移入和移出彈性集區。Single databases can be moved into and out of an elastic pool.

重要

若要了解 SQL Database 和 SQL Server 之間的功能差異,以及不同的 Azure SQL Database 部署選項之間的差異,請參閱 SQL 功能To understand the feature differences between SQL Database and SQL Server, as well as the differences between different Azure SQL Database deployment options, see SQL features.

SQL Database 提供具有多個資源類型、服務層級和計算大小的可預測效能,以提供無停機時間的動態延展性、內建智慧最佳化、全域延展性和可用性,以及進階安全性選項,且全都幾乎免管理。SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes that provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options — all with near-zero administration. 這些功能可讓您專注於快速開發應用程式及加快上市時間,而不是將寶貴的時間和資源耗費在管理虛擬機器和基礎結構上。These capabilities allow you to focus on rapid app development and accelerating your time to market, rather than allocating precious time and resources to managing virtual machines and infrastructure. SQL Database 服務目前在全球 38 個資料中心提供,還有更多資料中心會定期上線,可讓您在附近的資料中心執行您的資料庫。The SQL Database service is currently in 38 data centers around the world, with more data centers coming online regularly, which enables you to run your database in a data center near you.

可擴充的效能和集區Scalable performance and pools

SQL Database 的所有版本可都讓您定義將指派的資源數量。All flavors of SQL Database enables you to define the amount of resources that will be assigned.

  • 對於單一資料庫,每個資料庫都彼此隔離而且可攜,各自也都有保證數量的計算、記憶體和儲存體資源。With single databases, each database is isolated from each other and portable, each with its own guaranteed amount of compute, memory, and storage resources. SQL Database 會提供不同的計算、記憶體和儲存體資源滿足不同的需求,而且能夠動態增加和減少單一資料庫資源SQL Database provides different compute, memory, and storage resources for different needs - and the ability to dynamically scale single database resources up and down. 超大規模的服務層單一資料庫可讓您調整為 100 TB,快速備份和還原功能。The hyperscale service tier for single database enables you to scale to 100 TB, with fast backup and restore capabilities.
  • 使用彈性集區,您可以建立新的資料庫,也可以將單一資料庫移到資源集區來充分使用資源,並省下金錢,而且能夠動態增加或減少彈性集區資源With elastic pools, you can create new databases or move single databases into a resource pool to maximize the use of resources and save money - and the ability to dynamically scale elastic pool resources up and down.
  • 使用受控執行個體,每個執行個體會利用保證的資源與其他執行個體隔離。With managed instances, each managed instance is isolated from other instances with guaranteed resources. 在受管理的執行個體中,執行個體資料庫會共用一組資源,而且能夠動態增加或減少受控執行個體資源Within a managed instance, the instance databases share a set of resources - and the ability to dynamically scale managed instance resources up and down.

您可以在一般用途服務層級每個月依成本於一個小型單一資料庫中建置第一個應用程式,接著隨時在業務關鍵服務層級以手動或程式設計方式變更其服務層級,以符合您的解決方案需求。You can build your first app on a small, single database at a low cost per month in the general purpose service tier and then change its service tier manually or programmatically at any time to the business critical Service tier to meet the needs of your solution. 您的應用程式或客戶皆無須停機,即可調整效能。You can adjust performance without downtime to your app or to your customers. 動態延展性可讓您的資料庫以透明的方式回應快速變化的資源需求,並且讓您只需支付您所需的資源費用。Dynamic scalability enables your database to transparently respond to rapidly changing resource requirements and enables you to only pay for the resources that you need when you need them.

動態延展性與自動調整規模不同。Dynamic scalability is different from autoscale. 自動調整規模是指服務根據準則來自動調整規模,而動態延展性則允許在不停機的狀況下手動調整規模。Autoscale is when a service scales automatically based on criteria, whereas dynamic scalability allows for manual scaling without downtime. 單一資料庫支援手動的動態延展性,但不支援自動調整規模。A Single database supports manual dynamic scalability, but not autoscale. 如需「自動」 體驗,請考慮使用彈性集區,以根據個別資料庫的需求讓資料庫共用集區中的資源。For a more automatic experience, consider using elastic pools, which allow databases to share resources in a pool based on individual database needs. 不過,有一些指令碼可協助您對單一資料庫自動調整延展性。However, there are scripts that can help automate scalability for a single database. 如需範例,請參閱使用 PowerShell 來監視和調整單一資料庫的規模For an example, see Use PowerShell to monitor and scale a single database.

購買模型、服務層、計算大小和儲存體數量Purchasing models, service tiers, compute sizes, and storage amounts

SQL Database 提供兩種購買模型:SQL Database offers two purchasing models:

  • 以虛擬核心為基礎的購買模型可讓您選擇虛擬核心的數目、記憶體數量,以及儲存體的數量和速度。The vCore-based purchasing model lets you choose the number of vCores, the amount or memory, and the amount and speed of storage. 以虛擬核心為基礎的購買模型也可讓您使用適用於 SQL Server 的 Azure Hybrid Benefit,以節省成本。The vCore-based purchasing model also allows you to use Azure Hybrid Benefit for SQL Server to gain cost savings. 如需 Azure Hybrid Benefit 的詳細資訊,請參閱常見問題集For more information about the Azure Hybrid Benefit, see Frequently asked questions.
  • 以 DTU 為基礎的購買模型提供在下列三個服務層中混用的計算、記憶體、IO 資源,以支援各種資料庫工作負載 (輕量型到重量型)。The DTU-based purchasing model offers a blend of compute, memory, IO resources in three service tiers to support lightweight to heavyweight database workloads. 各層內的計算大小分別提供這些資源的不同混用方式,而且您可以為其新增額外的儲存體資源。Compute sizes within each tier provide a different mix of these resources, to which you can add additional storage resources.

可將資源使用量最大化的彈性集區Elastic pools to maximize resource utilization

對於許多企業和應用程式而言,只要能夠建立單一資料庫,並依需求調高或調低的效能即可,尤其是當使用模式相當容易預測時更是如此。For many businesses and applications, being able to create single databases and dial performance up or down on demand is enough, especially if usage patterns are relatively predictable. 但如果您有無法預測的使用模式,則管理成本和商務模式就會變得相當困難。But if you have unpredictable usage patterns, it can make it hard to manage costs and your business model. 彈性集區的設計可解決此問題。Elastic pools are designed to solve this problem. 概念很簡單。The concept is simple. 您可將效能資源配置到集區,而非個別的資料庫,並支付該集區的集體效能資源,而非單一資料庫效能的費用。You allocate performance resources to a pool rather than an individual database and pay for the collective performance resources of the pool rather than for single database performance.

彈性集區

使用彈性集區,您就不必隨著資源的需求波動,專注於調高或調低資料庫效能。With elastic pools, you don’t need to focus on dialing database performance up and down as demand for resources fluctuates. 集區資料庫會視需要取用彈性集區的效能資源。The pooled databases consume the performance resources of the elastic pool as needed. 集區資料庫會取用集區的資源,但不會超過其限制,因此您的成本可在個別資料庫使用情形無法預測的狀況下維持可預測性。Pooled databases consume but don’t exceed the limits of the pool, so your cost remains predictable even if individual database usage doesn’t. 此外,您還可以 將資料庫移入/移出集區,並將您的應用程式從數個資料庫擴充至數千個,而且全都在您可掌控的預算之內。What’s more, you can add and remove databases to the pool, scaling your app from a handful of databases to thousands, all within a budget that you control. 您也可以控制集區中資料庫可用的資源上限和下限,以確保集區中不會有任一資料庫使用所有的集區資源,且每個集區資料庫都有保證的最低資源數量。You can also control the minimum and maximum resources available to databases in the pool to ensure that no database in the pool uses all the pool resources and that every pooled database has a guaranteed minimum amount of resources. 若要深入了解使用彈性集區的 SaaS 應用程式的設計模式,請參閱 採用 SQL Database 的多租用戶 SaaS 應用程式的設計模式To learn more about design patterns for SaaS applications using elastic pools, see Design Patterns for Multi-tenant SaaS Applications with SQL Database.

指令碼可協助您監視及調整彈性集區的規模。Scripts can help with monitoring and scaling elastic pools. 如需範例,請參閱使用 PowerShell 在 Azure SQL Database 中監視和調整 SQL 彈性集區的規模For an example, see Use PowerShell to monitor and scale a SQL elastic pool in Azure SQL Database

重要

受控執行個體不支援彈性集區。A managed instance does not support elastic pools. 相反地,受控執行個體是共用受控執行個體資源的執行個體資料庫集合。Rather, a managed instance is a collection of instance databases that share managed instance resources.

混合使用單一資料庫與集區資料庫Blend single databases with pooled databases

您可以混合使用單一資料庫與彈性集區,並快速且輕易地變更單一資料庫和彈性集區的服務層級來適應您的情況。You can blend single databases with elastic pools and change the service tiers of single databases and elastic pools quickly and easily to adapt to your situation. 透過 Azure 功能強大而無遠弗屆的特性,您可以使用 SQL Database 混合和搭配其他 Azure 服務,滿足您獨特應用程式的設計需求、有效運用成本和資源,並且產生新的商機。With the power and reach of Azure, you can mix-and-match other Azure services with SQL Database to meet your unique app design needs, drive cost and resource efficiencies, and unlock new business opportunities.

廣泛的監視和警示功能Extensive monitoring and alerting capabilities

您可以使用內建的效能監視警示工具,並搭配使用效能分級。You use the built-in performance monitoring and alerting tools, combined with the performance ratings. 使用這些工具,您可以根據目前或專案的效能需求快速評估相應增加或減少的影響。Using these tools, you can quickly assess the impact of scaling up or down based on your current or project performance needs. 此外,SQL Database 可以發出計量和診斷記錄以便進行監視。Additionally, SQL Database can emit metrics and diagnostic logs for easier monitoring. 您可以將 SQL Database 設定為將資源使用量、背景工作與工作階段及連線儲存到下列其中一項 Azure 資源:You can configure SQL Database to store resource usage, workers and sessions, and connectivity into one of these Azure resources:

  • Azure 儲存體:用於封存大量遙測,價格實惠Azure Storage: For archiving vast amounts of telemetry for a small price

  • Azure 事件中樞:用於整合 SQL Database 遙測與自訂監視解決方案或經常性管線Azure Event Hub: For integrating SQL Database telemetry with your custom monitoring solution or hot pipelines

  • Azure 監視器記錄:適用於具有報告、警示及緩和功能的內建監視解決方案。Azure Monitor logs: For built-in monitoring solution with reporting, alerting, and mitigating capabilities.

    架構

可用性功能Availability capabilities

在傳統的 SQL Server 環境中,您通常會需要 (至少) 2 的機器本機設定使用的資料 (使用功能,例如 AlwaysOn 可用性群組或容錯移轉叢集執行個體) 的完整 (同步維護) 複本以防範單一機器/元件失敗。In a traditional SQL Server environment, you would generally have (at least) 2 machines locally set up with exact (synchronously maintained) copies of the data (using features like AlwaysOn availability groups or Failover Cluster Instances) to protect against a failure of a single machine/component. 這會提供高可用性,但無法防止破壞您的資料中心的天然災害。This provides high availability but does not protect against a natural disaster destroying your data center.

嚴重損壞修復假設的災難性事件,將地理位置會當地語系化足以由另一個電腦/機器資料的複本很遠的地方。Disaster recovery assumes that a catastrophic event will be geographically localized enough to have another machine/set of machines with a copy of your data far away. 在 SQL Server 中,您可以使用 Always On 可用性群組在非同步模式下執行以取得這項功能。In SQL Server, you could use Always On Availability Groups running in async mode to get this capability. 淺問題的速度通常表示使用者不想等候認可交易,因此沒有資料遺失的可能性當您執行非計劃性容錯移轉之前,很遠的地方發生複寫。The speed of light issues usually means that people do not want to wait for replication to happen that far away before committing a transaction, so there is potential for data loss when you do unplanned failovers.

資料庫中的進階和業務關鍵服務層已經類似可用性群組的同步處理。Databases in the premium and business critical service tiers already do something very similar to the synchronization of an availability group. 較低服務層中的資料庫提供備援,透過使用儲存體不同,但相當機制Databases in lower service tiers provide redundancy through storage using a different but equivalent mechanism. 沒有邏輯,可防止單一電腦失敗。There is logic that protects against a single machine failure. 作用中異地複寫功能讓您能夠防範災害終結的整個區域的位置。The active geo-replication feature gives you the ability to protect against disaster where a whole region is destroyed.

Azure 可用性區域是婧矔菛高可用性問題。Azure Availability Zones is a play on the high availability problem. 它會嘗試防止建置在單一區域內的單一資料中心中斷。It tries to protect against the outage of a single data center building within a single region. 因此,它想要防止斷電或網路來建置。So, it wants to protect against the loss of power or network to a building. 在 SQL Azure,這適用於將不同的複本放在不同的可用性區域 (不同的大樓,有效地),否則使用和以前一樣。In SQL Azure, this will work by placing the different replicas in different availability zones (different buildings, effectively) and otherwise working as before.

事實上,Azure 的業界領先的 99.99%可用性服務等級協定(SLA),由 Microsoft 管理的資料中心全球網路,可協助確保您的應用程式執行 24/7。In fact, Azure's industry leading 99.99% availability service level agreement (SLA), powered by a global network of Microsoft-managed datacenters, helps keep your app running 24/7. Azure 平台可完全管理每個資料庫,並保證任何資料都不會遺失及高度的資料可用性。The Azure platform fully manages every database and guarantees no data loss and high percentage of data availability. Azure 會自動處理修補、備份、複寫、失敗偵測,基礎潛在硬體、軟體或網路失敗、部署錯誤修正、容錯移轉、資料庫升級和其他維護工作。Azure automatically handles patching, backups, replication, failure detection, underlying potential hardware, software or network failures, deploying bug fixes, failovers, database upgrades and other maintenance tasks. 隔離計算和儲存圖層可達成標準可用性。Standard availability is achieved by a separation of compute and storage layers. 整合單一節點上的計算和儲存以獲取效能,然後另外實作類似 Always On 可用性群組的技術,則可達成進階可用性。Premium availability is achieved by integrating compute and storage on a single node for performance and then implementing technology similar to Always On Availability Groups under the covers. 如需 Azure SQL Database 高可用性功能的完整討論,請參閱 SQL Database 可用性For a full discussion of the high availability capabilities of Azure SQL Database, see SQL Database availability. 此外,SQL Database 還提供內建業務持續性和全域延展性功能,包括:In addition, SQL Database provides built-in business continuity and global scalability features, including:

  • 自動備份Automatic backups:

    SQL Database 會自動執行 Azure SQL 資料庫的完整、差異及交易記錄備份,以供您還原至任何時間點。SQL Database automatically performs full, differential, and transaction log backups of Azure SQL databases to enable you to restore to any point in time. 對於單一資料庫和集區資料庫,您可以設定 SQL 資料庫將完整資料庫備份儲存至 Azure 儲存體,以供長期備份保留。For single databases and pooled databases, you can configure SQL Database to store full database backups to Azure storage for long-term backup retention. 對於受控執行個體,您也可以對僅複製備份執行長期備份保留。For managed instances, you can also perform copy-only backups for long-term backup retention.

  • 時間點還原Point-in-time restores:

    所有 SQL Database 部署選項均支援復原到任何 Azure SQL 資料庫自動備份保留期間內的任何時間點。All SQL Database deployment options support recovery to any point in time within the automatic backup retention period for any Azure SQL database.

  • 主動式異地複寫Active geo-replication:

    單一資料庫和集區資料庫可讓您在相同或全域分散的 Azure 資料中心最多設定四個可讀取的次要資料庫。Single database and pooled databases allow you to configure up to four readable secondary databases in either the same or globally distributed Azure data centers. 例如,如果 SaaS 應用程式的目錄資料庫有大量的並行唯讀交易,請使用主動式異地複寫功能來啟用全域讀取範圍,並移除主要資料庫上因為讀取工作負載所造成的瓶頸。For example, if you have a SaaS application with a catalog database that has a high volume of concurrent read-only transactions, use active geo-replication to enable global read scale and remove bottlenecks on the primary that are due to read workloads. 對於受控執行個體,請使用自動容錯移轉群組。For managed instances, use auto-failover groups.

  • 自動容錯移轉群組Auto-failover groups:

    所有 SQL Database 部署選項均可讓您使用容錯移轉群組來全面啟用高可用性和負載平衡,包括大量資料庫、彈性集區和受控執行個體的透明異地複寫和容錯移轉。All SQL Database deployment options allow you to use failover groups to enable high availability and load balancing at global scale, including transparent geo-replication and failover of large sets of databases, elastic pools, and managed instances. 容錯移轉群組能夠建立全域分散的 SaaS 應用程式,其管理負擔最小,可讓 SQL Database 處理所有複雜的監視、路由傳送及容錯移轉協調流程。Failover groups enable the creation of globally distributed SaaS applications with minimal administration overhead leaving all the complex monitoring, routing, and failover orchestration to SQL Database.

  • 區域備援資料庫Zone-redundant databases:

    SQL Database 可讓您跨多個可用性區域佈建進階或業務關鍵資料庫或彈性集區。SQL Database allows you to provision premium or business critical databases or elastic pools across multiple availability zones. 由於這些資料庫和彈性集區有多個備援複本可提供高可用性,所以將這些複本放入多個可用性區域即可提供更高的復原能力,包括能夠從資料中心規模的失敗自動復原,而不會遺失任何資料。Because these databases and elastic pools have multiple redundant replicas for high availability, placing these replicas into multiple availability zones provides higher resilience, including the ability to recover automatically from the datacenter scale failures without data loss.

內建智慧Built-in intelligence

採用 SQL Database,您可取得內建智慧來協助您大幅降低執行和管理資料庫的成本,並將應用程式的效能和安全性最大化。With SQL Database, you get built-in intelligence that helps you dramatically reduce the costs of running and managing databases and maximizes both performance and security of your application. SQL Database 隨時執行數以百萬計的客戶工作負載,並收集和處理大量的遙測資料,同時完全尊重幕後的客戶隱私權。Running millions of customer workloads around-the-clock, SQL Database collects and processes a massive amount of telemetry data, while also fully respecting customer privacy behind the scenes. 各種演算法會持續評估遙測資料,讓服務能夠了解您的應用程式並隨之調整。Various algorithms are continuously evaluating the telemetry data so that the service can learn and adapt with your application. 根據這項分析,服務會提出針對特定工作負載量身訂做的效能改善建議。Based on this analysis, the service comes up with performance improving recommendations tailored to your specific workload.

自動的效能監視和微調Automatic performance monitoring and tuning

SQL Database 會提供您需要監視之查詢的詳細解析。SQL Database provides detailed insight into the queries that you need to monitor. SQL Database 會了解您的資料庫模式,並可讓您根據您的工作負載調整資料庫結構描述。SQL Database's learns about your database patterns and enables you to adapt your database schema to your workload. SQL Database 提供效能微調建議,您可以在其中檢閱微調動作並加以套用。SQL Database provides performance tuning recommendations, where you can review tuning actions and apply them.

不過,持續監視資料庫是冗長乏味的艱辛工作,尤其是在處理許多資料庫時。However, constantly monitoring database is a hard and tedious task, especially when dealing with many databases. 智慧型深入解析會自動地大規模監視 SQL Database 效能來替您代勞,並通知效能降低的問題,還會識別問題的根本原因,然後盡可能提供效能改善建議。Intelligent Insights does this job for you by automatically monitoring SQL Database performance at scale and it informs you of performance degradation issues, it identifies the root cause of the issue and provides performance improvement recommendations when possible.

即使使用 SQL Database 和 Azure 入口網站提供的所有可用工具和報告,都可能無法有效率地管理大量資料庫。Managing a huge number of databases might be impossible to do efficiently even with all available tools and reports that SQL Database and Azure portal provide. 除了手動監視和調整資料庫,您也可以考慮使用自動調整,將一些監視和微調動作委派給 SQL Database。Instead of monitoring and tuning your database manually, you might consider delegating some of the monitoring and tuning actions to SQL Database using automatic tuning. SQL Database 會自動套用建議、測試及驗證每個調整動作,以確保持續改善效能。SQL Database automatically apply recommendations, tests, and verifies each of its tuning actions to ensure the performance keeps improving. 如此一來,SQL Database 會以受控制且安全的方式自動調整您的工作負載。This way, SQL Database automatically adapts to your workload in controlled and safe way. 自動調整表示在每個調整動作前後,資料庫效能都會受到仔細的監控和比較,而如果效能沒有改善,則會還原調整動作。Automatic tuning means that the performance of your database is carefully monitored and compared before and after every tuning action, and if the performance doesn’t improve, the tuning action is reverted.

現今,在 SQL Database 之上執行 SaaS 多租用戶應用程式的許多合作夥伴都依賴自動效能微調,來確保其應用程式始終擁有穩定且可預測的效能。Today, many of our partners running SaaS multi-tenant apps on top of SQL Database are relying on automatic performance tuning to make sure their applications always have stable and predictable performance. 對他們而言,這項功能可大幅降低夜間發生效能事件的風險。For them, this feature tremendously reduces the risk of having a performance incident in the middle of the night. 此外,由於其部分客戶也使用 SQL Server,所以他們會使用 SQL Database 所提供的相同索引建議來協助其 SQL Server 客戶。In addition, since part of their customer base also uses SQL Server, they are using the same indexing recommendations provided by SQL Database to help their SQL Server customers.

SQL Database 中可用的自動調整層面有兩個:There are two automatic tuning aspects that are available in SQL Database:

  • 自動索引管理:識別應加入您資料庫的索引,以及應移除的索引。Automatic index management: Identifies indexes that should be added in your database, and indexes that should be removed.
  • 自動計劃修正:識別有問題的計劃並修正 SQL 計劃效能問題 (即將推出,已可在 SQL Server 2017 中取得)。Automatic plan correction: Identifies problematic plans and fixes SQL plan performance problems (coming soon, already available in SQL Server 2017).

自適性查詢處理Adaptive query processing

我們也將自適性查詢處理功能系列新增至 SQL Database,包括交錯執行多陳述式的資料表值函式、批次模式記憶體授與意見反應,以及批次模式自適性聯結。We are also adding the adaptive query processing family of features to SQL Database, including interleaved execution for multi-statement table-valued functions, batch mode memory grant feedback, and batch mode adaptive joins. 每個自適性查詢處理功能都會應用類似的「了解並適應」技術,協助進一步解決與過去很棘手的查詢最佳化問題相關的效能問題。Each of these adaptive query processing features applies similar “learn and adapt” techniques, helping further address performance issues related to historically intractable query optimization problems.

進階安全性與合規性Advanced security and compliance

SQL Database 提供了各式各樣的內建安全性與合規性功能,協助您的應用程式符合各種安全性與合規性需求。SQL Database provides a range of built-in security and compliance features to help your application meet various security and compliance requirements.

重要

Azure SQL Database (所有部署選項)、 經過認證符合許多法規標準。Azure SQL Database (all deployment options), has been certified against a number of compliance standards. 如需詳細資訊,請參閱 < Microsoft Azure 信任中心您可以在此找到最新的 SQL Database 的合規性認證清單。For more information, see the Microsoft Azure Trust Center where you can find the most current list of SQL Database compliance certifications.

進階威脅保護Advance Threat Protection

進階資料安全性是進階 SQL 安全性功能的整合套件。Advanced data security is a unified package for advanced SQL security capabilities. 其中包含探索及分類敏感性資料、管理資料庫弱點,以及偵測可能表示對資料庫有威脅之異常活動的功能。It includes functionality for discovering and classifying sensitive data, managing your database vulnerabilities, and detecting anomalous activities that could indicate a threat to your database. 此套件可讓您從單一的進入點位置啟用及管理前述功能。It provides a single go-to location for enabling and managing these capabilities.

  • 資料探索與分類Data discovery & classification:

    這個功能 (目前處於預覽階段) 提供內建於 Azure SQL Database 的功能,可用來探索、分類、標記和保護資料庫中的敏感性資料。This feature (currently in preview) provides capabilities built into Azure SQL Database for discovering, classifying, labeling & protecting the sensitive data in your databases. 它可用來讓您檢視資料庫分類狀態、追蹤對資料庫內敏感性資料的存取,並具有其他多方面的用途。It can be used to provide visibility into your database classification state, and to track the access to sensitive data within the database and beyond its borders.

  • 弱點評量Vulnerability assessment:

    這個服務可以探索、追蹤並協助您修復潛在的資料庫弱點。This service can discover, track, and help you remediate potential database vulnerabilities. 它可讓您檢視安全性狀態,且包含解決安全性問題和增強資料庫防護性的可行步驟。It provides visibility into your security state, and includes actionable steps to resolve security issues, and enhance your database fortifications.

  • 威脅偵測Threat detection:

    這個功能可偵測異常活動,指出有不尋常及可能有害的活動試圖存取或惡意探索您的資料庫。This feature detects anomalous activities indicating unusual and potentially harmful attempts to access or exploit your database. 它會持續監視您的資料庫是否有可疑的活動,並在發現潛在弱點、SQL 插入式攻擊和異常資料庫存取模式時提供即時安全性警示。It continuously monitors your database for suspicious activities, and provides immediate security alerts on potential vulnerabilities, SQL injection attacks, and anomalous database access patterns. 威脅偵測警示會提供可疑活動的詳細資料,以及如何調查與降低威脅的建議。Threat detection alerts provide details of the suspicious activity and recommend action on how to investigate and mitigate the threat.

合規性和安全性稽核Auditing for compliance and security

稽核會追蹤資料庫事件,並將它們寫入至您 Azure 儲存體帳戶中的稽核記錄。Auditing tracks database events and writes them to an audit log in your Azure storage account. 稽核可協助您保持法規遵循、了解資料庫活動,以及深入了解可指出商務考量或疑似安全違規的不一致和異常。Auditing can help you maintain regulatory compliance, understand database activity, and gain insight into discrepancies and anomalies that could indicate business concerns or suspected security violations.

資料加密Data encryption

SQL Database 會使用傳輸層安全性為移動中的資料提供加密、使用透明資料加密為待用資料提供加密,以及使用一律加密為使用中的資料提供加密,來保護您的資料安全。SQL Database secures your data by providing encryption for data in motion with transport layer security, for data at rest with transparent data encryption, and for data in use with always encrypted.

Azure Active Directory 整合和多重要素驗證Azure Active Directory integration and multi-factor authentication

SQL Database 可讓您透過 Azure Active Directory 整合,集中管理資料庫使用者和其他 Microsoft 服務的身分識別。SQL Database enables you to centrally manage identities of database user and other Microsoft services with Azure Active Directory integration. 這項功能簡化了權限管理並增強安全性。This capability simplifies permission management and enhances security. Azure Active Directory 支援多重要素驗證 (MFA),以提高資料和應用程式安全性,同時支援單一登入程序。Azure Active Directory supports multi-factor authentication (MFA) to increase data and application security while supporting a single sign-in process.

合規性認證Compliance certification

SQL Database 會參與定期稽核,並已經過數個合規性標準的認證。SQL Database participates in regular audits and has been certified against several compliance standards. 如需詳細資訊,請參閱 < Microsoft Azure 信任中心您可以在此找到最新的 SQL Database 的合規性認證清單。For more information, see the Microsoft Azure Trust Center where you can find the most current list of SQL Database compliance certifications.

容易使用Easy-to-use tools

SQL Database 讓應用程式的建置及維護更簡易也更有生產力。SQL Database makes building and maintaining applications easier and more productive. SQL Database 讓您將精力集中於拿手項目:建置絕佳的應用程式。SQL Database allows you to focus on what you do best: building great apps. 您可以使用已經擁有的工具和技巧,在 SQL Database 中進行管理和開發。You can manage and develop in SQL Database using tools and skills you already have.

  • Azure 入口網站The Azure portal:

    網頁型應用程式,可用於管理所有 Azure 服務A web-based application for managing all Azure services

  • SQL Server Management StudioSQL Server Management Studio:

    可下載的免費用戶端應用程式,可用於管理任何 SQL 基礎結構 (從 SQL Server 到 SQL Database)A free, downloadable client application for managing any SQL infrastructure, from SQL Server to SQL Database

  • Visual Studio 中的 SQL Server Data ToolsSQL Server Data Tools in Visual Studio:

    可下載的免費用戶端應用程式,可用於開發 SQL Server 關聯式資料庫、Azure SQL 資料庫、Integration Services 套件、Analysis Services 資料模型及 Reporting Services 報告。A free, downloadable client application for developing SQL Server relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services reports.

  • Visual Studio CodeVisual Studio Code:

    免費、可下載、開放原始碼的程式碼編輯器,適用於支援擴充功能的 Windows、macOS 和 Linux,包括可供查詢 Microsoft SQL Server、Azure SQL Database 和 SQL 資料倉儲的 mssql 擴充功能A free, downloadable, open-source, code editor for Windows, macOS, and Linux that supports extensions, including the mssql extension for querying Microsoft SQL Server, Azure SQL Database, and SQL Data Warehouse.

SQL Database 支援在 MacOS、Linux 和 Windows 上使用 Python、Java、Node.js、PHP、Ruby 和 .NET 建置應用程式。SQL Database supports building applications with Python, Java, Node.js, PHP, Ruby, and .NET on the MacOS, Linux, and Windows. SQL Database 支援與 SQL Server 相同的連線庫SQL Database supports the same connection libraries as SQL Server.

SQL Database 常見問題集 (FAQ)SQL Database frequently asked questions (FAQ)

最新的 SQL Database 版本為何What is the current version of SQL Database

最新的 SQL Database 版本是 V12。The current version of SQL Database is V12. 版本 V11 已被淘汰。Version V11 has been retired.

我能否控制修補停機時間何時發生Can I control when patching downtime occurs

資料分割No. 如果您在應用程式中採用重試邏輯,修補的影響通常不明顯。The impact of patching is generally not noticeable if you employ retry logic in your app. 如需關於如何對 Azure SQL 資料庫上的計劃性維護事件進行準備的詳細資訊,請參閱規劃 Azure SQL Database 的 Azure 維護事件For more information about how to prepare for planned maintenance events on your Azure SQL database, see planning for Azure maintenance events in Azure SQL Database.

Azure Hybrid Benefit 問題Azure Hybrid Benefit questions

適用於 SQL Server 的 Azure Hybrid Benefit 是否有雙重使用權Are there dual-use rights with Azure Hybrid Benefit for SQL Server

對於此授權,您具有 180 天的雙重使用權,以確保移轉能順暢地執行。You have 180 days of dual use rights of the license to ensure migrations are running seamlessly. 180 天的期間結束後,SQL Server 授權就只能用於雲端的 SQL Database 中,且在內部部署和雲端中都沒有雙重使用權。After that 180-day period, the SQL Server license can only be used in the cloud in SQL Database, and does not have dual use rights on-premises and in the cloud.

適用於 SQL Server 的 Azure Hybrid Benefit 與授權行動性有何不同How does Azure Hybrid Benefit for SQL Server differ from license mobility

我們現在為 SQL Server 客戶提供的軟體保證授權行動性權益,允許客戶將其授權重新指派給第三方共用伺服器。Today, we offer license mobility benefits to SQL Server customers with Software Assurance that allows re-assignment of their licenses to third-party shared servers. 此權益可用於 Azure IaaS 和 AWS EC2。This benefit can be used on Azure IaaS and AWS EC2. 適用於 SQL Server 的 Azure Hybrid Benefit 主要在以下兩方面與授權行動性有所差異:Azure Hybrid Benefit for SQL Server differs from license mobility in two key areas:

  • 它提供將高度虛擬化工作負載移轉至 Azure 的經濟效益。It provides economic benefits for moving highly virtualized workloads to Azure. 在一般目的 SKU 中,SQL EE 客戶在內部部署所擁有的每個核心,將可使其在 Azure 中獲得 4 個核心,以用於高度虛擬化應用程式。SQL EE customers can get 4 cores in Azure in the General Purpose SKU for every core they own on-premises for highly virtualized applications. 授權行動性並不允許將虛擬化工作負載移轉至雲端的任何特殊成本優勢。License mobility does not allow any special cost benefits for moving virtualized workloads to the cloud.
  • 它是針對 Azure 上與內部部署 SQL Server 高度相容的 PaaS 目的地 (SQL Database 受控執行個體) 而提供的。It provides for a PaaS destination on Azure (SQL Database Managed Instance) that is highly compatible with SQL Server on-premises

適用於 SQL Server 的 Azure Hybrid Benefit 有哪些明確的權利What are the specific rights of the Azure Hybrid Benefit for SQL Server

SQL Database 客戶將會有下列與適用於 SQL Server 的 Azure Hybrid Benefit 相關聯的權利:SQL Database customers will have the following rights associated with Azure Hybrid Benefit for SQL Server:

授權情形License Footprint 適用於 SQL Server 的 Azure Hybrid Benefit 對您而言有何功能?What does Azure Hybrid Benefit for SQL Server Get You?
具有 SA 的 SQL Server Enterprise Edition 核心客戶SQL Server Enterprise Edition core customers with SA
  • 使用一般目的或業務關鍵 SKU 時可支付基本費率Can pay Base Rate on either General Purpose or Business Critical SKU

  • 1 個內部部署核心 = 一般目的 SKU 中的 4 個核心1 core on-premises = 4 cores in General Purpose SKU

  • 1 個內部部署核心 = 業務關鍵 SKU 中的 1 個核心1 core on-premises = 1 core in Business Critical SKU
  • 具有 SA 的 SQL Server Standard Edition 核心客戶SQL Server Standard Edition core customers with SA
  • 只有使用一般目的 SKU 時才可支付基本費率Can pay Base Rate on General Purpose SKU only

  • 1 個內部部署核心 = 一般目的 SKU 中的 1 個核心1 core on-premises = 1 core in General Purpose SKU
  • 洽詢 SQL Server 工程團隊Engage with the SQL Server engineering team

    後續步驟Next steps