一般用途服務層級-Azure SQL Database 和 Azure SQL 受控執行個體General Purpose service tier - Azure SQL Database and Azure SQL Managed Instance

適用於: Azure SQL Database Azure SQL 受控執行個體

注意

以 vCore 為基礎的購買模型中的一般用途服務層級,在以 DTU 為基礎的購買模型中稱為標準服務層級。The General Purpose service tier in the vCore-based purchasing model is called the standard service tier in the DTU-based purchasing model. 如需以 DTU 為基礎的購買模型比較 vCore 為基礎的購買模型,請參閱 購買模型和資源For a comparison of the vCore-based purchasing model with the DTU-based purchasing model, see purchasing models and resources.

Azure SQL Database 和 Azure SQL 受控執行個體是以針對雲端環境調整的 SQL Server 資料庫引擎架構為基礎,以確保即使在基礎結構失敗的情況下,仍可確保99.99% 的可用性。Azure SQL Database and Azure SQL Managed Instance are based on the SQL Server database engine architecture adapted for the cloud environment in order to ensure 99.99% availability even in the cases of infrastructure failures.

Azure SQL Database 和 SQL 受控執行個體使用兩個服務層級:There are two service tiers used by Azure SQL Database and SQL Managed Instance:

  • 一般用途General Purpose
  • 業務關鍵Business Critical

Azure SQL Database 也有第三個服務層級,目前無法用於 Azure SQL 受控執行個體:Azure SQL Database also has a third service tier, which is currently unavailable for Azure SQL Managed Instance:

  • 超大規模資料庫Hyperscale

一般用途服務層的架構模型是以計算和儲存體的分隔為基礎。The architectural model for the General Purpose service tier is based on a separation of compute and storage. 此架構模型仰賴 Azure Blob 儲存體的高可用性和可靠性,可以透明的方式複寫資料庫檔案,並保證當基礎結構發生失敗時也不會遺失資料。This architectural model relies on high availability and reliability of Azure Blob storage that transparently replicates database files and guarantees no data loss if underlying infrastructure failure happens.

下圖顯示標準架構模型中具有分隔計算和儲存體層的四個節點。The following figure shows four nodes in standard architectural model with the separated compute and storage layers.

分隔計算與儲存體

在一般用途服務層級的架構模型中,有兩個層級:In the architectural model for the General Purpose service tier, there are two layers:

  • 無狀態計算層,執行 sqlservr.exe 流程並且僅包含暫時性和快取資料 (例如計畫快取、緩衝集區、列儲存集區)。A stateless compute layer that is running the sqlservr.exe process and contains only transient and cached data (for example – plan cache, buffer pool, column store pool). 此無狀態節點是由 Azure Service Fabric 操作,可將進程初始化、控制節點的健全狀況,並在必要時執行容錯移轉至另一個位置。This stateless node is operated by Azure Service Fabric that initializes process, controls health of the node, and performs failover to another place if necessary.
  • 具狀態資料層,包含儲存在 Azure Blob 儲存體中的資料庫檔案 (.mdf/.ldf)。A stateful data layer with database files (.mdf/.ldf) that are stored in Azure Blob storage. Azure Blob 可確保任何資料庫檔案中放置的任何記錄都不會遺失資料。Azure Blob storage guarantees that there will be no data loss of any record that is placed in any database file. Azure 儲存體具有內建的資料可用性/冗余,可確保即使進程損毀,也會保留資料檔案中記錄檔或頁面中的每筆記錄。Azure Storage has built-in data availability/redundancy that ensures that every record in log file or page in data file will be preserved even if the process crashes.

每次升級資料庫引擎或作業系統時,基礎結構的某些部分會失敗,或者如果在此程式中偵測到某個重大問題 sqlservr.exe ,Azure Service Fabric 會將無狀態程式移至另一個無狀態計算節點。Whenever the database engine or operating system is upgraded, some part of underlying infrastructure fails, or if some critical issue is detected in the sqlservr.exe process, Azure Service Fabric will move the stateless process to another stateless compute node. 主要節點發生容錯移轉時,會有一組備用節點等候執行新的計算服務,以便將容錯移轉的時間縮到最短。There is a set of spare nodes that is waiting to run new compute service if a failover of the primary node happens in order to minimize failover time. Azure 儲存體層中的資料不會受到影響,而且資料/記錄檔會附加到新初始化的進程。Data in Azure storage layer is not affected, and data/log files are attached to newly initialized process. 此程式可保證99.99% 的可用性,但由於轉換時間和新節點以冷快取啟動,因此可能會對正在執行的繁重工作負載產生一些效能影響。This process guarantees 99.99% availability, but it might have some performance impacts on heavy workloads that are running due to transition time and the fact the new node starts with cold cache.

選擇此服務層級的時機When to choose this service tier

一般用途服務層級是 Azure SQL Database 的預設服務層級,而 Azure SQL 受控執行個體是針對大部分的一般工作負載所設計。The General Purpose service tier is a default service tier in Azure SQL Database and Azure SQL Managed Instance that is designed for most of generic workloads. 如果您需要完全受控的資料庫引擎(具有 99.99% SLA),且在大部分情況下符合 Azure 虛擬機器上 SQL Server 的5到10毫秒之間的儲存體延遲,一般用途層就是您可以選擇的選項。If you need a fully managed database engine with 99.99% SLA with storage latency between 5 and 10 ms that match SQL Server on an Azure virtual machine in most of the cases, the General Purpose tier is the option for you.

接下來的步驟Next steps