vCore 模型總覽-Azure SQL Database 和 Azure SQL 受控執行個體vCore model overview - Azure SQL Database and Azure SQL Managed Instance

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

Azure SQL Database 和 Azure SQL 受控執行個體所使用的虛擬核心 (vCore) 購買模型可提供數個優點:The virtual core (vCore) purchasing model used by Azure SQL Database and Azure SQL Managed Instance provides several benefits:

  • 更高的計算、記憶體、i/o 和儲存體限制。Higher compute, memory, I/O, and storage limits.
  • 控制硬體世代,以更符合工作負載的計算和記憶體需求。Control over the hardware generation to better match compute and memory requirements of the workload.
  • Azure Hybrid Benefit (AHB) 保留實例 (RI) 的定價折扣。Pricing discounts for Azure Hybrid Benefit (AHB) and Reserved Instance (RI).
  • 更清楚的硬體詳細資料,可加速計算,以促進從內部部署部署進行遷移的規劃。Greater transparency in the hardware details that power the compute, that facilitates planning for migrations from on-premises deployments.

服務層Service tiers

VCore 模型中的服務層選項包括一般用途、業務關鍵和超大規模。Service tier options in the vCore model include General Purpose, Business Critical, and Hyperscale. 服務層通常會定義與可用性和嚴重損壞修復相關的儲存體架構、空間和 i/o 限制,以及商務持續性選項。The service tier generally defines the storage architecture, space and I/O limits, and business continuity options related to availability and disaster recovery.

- 一般用途General Purpose 業務關鍵Business Critical 超大規模資料庫Hyperscale
適用對象Best for 大部分的商業工作負載。Most business workloads. 提供以預算為導向、平衡且可調整的計算和儲存體選項。Offers budget-oriented, balanced, and scalable compute and storage options. 使用數個隔離的複本,為商務應用程式提供失敗的最高復原能力,並為每個資料庫複本提供最高的 i/o 效能。Offers business applications the highest resilience to failures by using several isolated replicas, and provides the highest I/O performance per database replica. 大部分具有可高度擴充之儲存體和讀取規模需求的商務工作負載。Most business workloads with highly scalable storage and read-scale requirements. 藉由允許設定一個以上的獨立資料庫複本,提供更高的失敗復原能力。Offers higher resilience to failures by allowing configuration of more than one isolated database replica.
儲存體Storage 使用遠端儲存體。Uses remote storage.
SQL Database 布建的計算SQL Database provisioned compute :
5 GB – 4 TB5 GB – 4 TB
無伺服器計算Serverless compute :
5 GB-3 TB5 GB - 3 TB
SQL 受控執行個體 : 32 GB-8 TBSQL Managed Instance : 32 GB - 8 TB
使用本機 SSD 儲存體。Uses local SSD storage.
SQL Database 布建的計算SQL Database provisioned compute :
5 GB – 4 TB5 GB – 4 TB
SQL 受控執行個體SQL Managed Instance :
32 GB - 4 TB32 GB - 4 TB
視需要彈性地自動成長儲存體。Flexible autogrow of storage as needed. 最多可支援 100 TB 的儲存體。Supports up to 100 TB of storage. 使用本機 SSD 儲存體進行本機緩衝集區快取和本機資料儲存。Uses local SSD storage for local buffer-pool cache and local data storage. 使用 Azure 遠端儲存體作為最終長期資料存放區。Uses Azure remote storage as final long-term data store.
IOPS 和輸送量 (大約) IOPS and throughput (approximate) SQL Database :請參閱 單一資料庫彈性集區的資源限制。SQL Database : See resource limits for single databases and elastic pools.
SQL 受控執行個體 :請參閱 總覽 Azure SQL 受控執行個體資源限制SQL Managed Instance : See Overview Azure SQL Managed Instance resource limits.
查看 單一資料庫彈性集區的資源限制。See resource limits for single databases and elastic pools. 超大規模是多層式架構,可在多個層級進行快取。Hyperscale is a multi-tiered architecture with caching at multiple levels. 有效的 IOPS 和輸送量會視工作負載而定。Effective IOPS and throughput will depend on the workload.
可用性Availability 1個複本,沒有讀取規模複本1 replica, no read-scale replicas 3 個複本、1 個讀取規模複本3 replicas, 1 read-scale replica,
區域冗余高可用性 (HA) zone-redundant high availability (HA)
1個讀寫複本,加上0-4 個 讀取規模複本1 read-write replica, plus 0-4 read-scale replicas
備份Backups 讀取權限異地冗余儲存體 (GRS) ,7-35 天 (預設為7天) Read-access geo-redundant storage (RA-GRS), 7-35 days (7 days by default) GRS、7-35 天 (預設為7天) RA-GRS, 7-35 days (7 days by default) Azure 遠端儲存體中以快照集為基礎的備份。Snapshot-based backups in Azure remote storage. 還原時可使用這些快照集進行快速復原。Restores use these snapshots for fast recovery. 備份是瞬間的,不會影響計算 i/o 效能。Backups are instantaneous and don't impact compute I/O performance. 還原速度很快,而且不是資料大小的作業 (需要幾分鐘的時間,而不是) 。Restores are fast and aren't a size-of-data operation (taking minutes rather than hours or days).
記憶體內In-memory 不支援Not supported 支援Supported 不支援Not supported

選擇服務層級Choosing a service tier

如需為您的特定工作負載選取服務層級的詳細資訊,請參閱下列文章:For information on selecting a service tier for your particular workload, see the following articles:

計算層Compute tiers

VCore 模型中的計算層選項包括布建和無伺服器計算層級。Compute tier options in the vCore model include the provisioned and serverless compute tiers.

佈建計算Provisioned compute

布建的計算層提供了特定數量的計算資源,這些資源會隨著工作負載活動而持續布建,並針對每小時固定價格布建的計算數量計費。The provisioned compute tier provides a specific amount of compute resources that are continuously provisioned independent of workload activity, and bills for the amount of compute provisioned at a fixed price per hour.

無伺服器計算Serverless compute

無伺服器計算層會根據工作負載活動自動調整計算資源,並依每秒使用的計算量來計費。The serverless compute tier auto-scales compute resources based on workload activity, and bills for the amount of compute used per second.

硬體世代Hardware generations

VCore 模型中的硬體世代選項包括 Gen 4/5、M 系列和 Fsv2 系列。Hardware generation options in the vCore model include Gen 4/5, M-series, and Fsv2-series. 硬體世代通常會定義計算和記憶體限制,以及影響工作負載效能的其他特性。The hardware generation generally defines the compute and memory limits and other characteristics that impact the performance of the workload.

第4代/第5代Gen4/Gen5

  • 第4代/第5代硬體提供平衡的計算和記憶體資源,適用于大部分的資料庫工作負載,這些工作負載沒有較高的記憶體、更高的 vCore,或是 Fsv2 系列或 M 系列所提供的單一 vCore 需求更快。Gen4/Gen5 hardware provides balanced compute and memory resources, and is suitable for most database workloads that do not have higher memory, higher vCore, or faster single vCore requirements as provided by Fsv2-series or M-series.

如需第4代/第5代的可用區域,請參閱 第4代/第5代可用性For regions where Gen4/Gen5 is available, see Gen4/Gen5 availability.

Fsv2 系列Fsv2-series

  • Fsv2 系列是一種計算優化的硬體選項,可針對 CPU 需求最高的工作負載提供低 CPU 延遲和高頻率速度。Fsv2-series is a compute optimized hardware option delivering low CPU latency and high clock speed for the most CPU demanding workloads.
  • 根據工作負載,Fsv2 系列可提供比第5代更多的每個 vCore CPU 效能,而 72 vCore 大小可提供比虛擬核心上的80第5代更高的 CPU 效能。Depending on the workload, Fsv2-series can deliver more CPU performance per vCore than Gen5, and the 72 vCore size can provide more CPU performance for less cost than 80 vCores on Gen5.
  • Fsv2 比其他硬體提供的每個 vCore 較少的記憶體和 tempdb,因此對這些限制敏感的工作負載可能會想要改用第5代或 M 系列。Fsv2 provides less memory and tempdb per vCore than other hardware so workloads sensitive to those limits may want to consider Gen5 or M-series instead.  

只有一般用途層才支援 Fsv2 系列。Fsv2-series in only supported in the General Purpose tier. 如需 Fsv2 系列的可用區域,請參閱 Fsv2 系列可用性For regions where Fsv2-series is available, see Fsv2-series availability.

M 系列M-series

  • M 系列是記憶體優化的硬體選項,適用于需要更多記憶體和更高計算限制的工作負載,但第5代不提供。M-series is a memory optimized hardware option for workloads demanding more memory and higher compute limits than provided by Gen5.
  • M 系列提供每個 vCore 29 GB 和最高128虛擬核心,這會將相對於 8 GB 的記憶體限制增加至將近 4 TB。M-series provides 29 GB per vCore and up to 128 vCores, which increases the memory limit relative to Gen5 by 8x to nearly 4 TB.

只有在業務關鍵層中才支援 M 系列,且不支援區域冗余。M-series is only supported in the Business Critical tier and does not support zone redundancy. 如需 M 系列的可用區域,請參閱 m 系列可用性For regions where M-series is available, see M-series availability.

M 系列支援的 Azure 供應專案類型Azure offer types supported by M-series

若要存取 M 系列,訂用帳戶必須是付費供應專案類型,包括隨用隨付或 Enterprise 合約 (EA) 。To access M-series, the subscription must be a paid offer type including Pay-As-You-Go or Enterprise Agreement (EA). 如需 M 系列所支援之 Azure 供應專案類型的完整清單,請參閱目前的供應專案, 但不含消費限制For a complete list of Azure offer types supported by M-series, see current offers without spending limits.

計算和記憶體規格Compute and memory specifications

硬體世代Hardware generation 計算Compute 記憶體Memory
Gen4Gen4 -Intel® E5-2673 v3 (Haswell) 2.4 GHz 處理器- Intel® E5-2673 v3 (Haswell) 2.4 GHz processors
-最多可布建至24個虛擬核心 (1 vCore = 1 個實體核心) - Provision up to 24 vCores (1 vCore = 1 physical core)
-每個 vCore 7 GB- 7 GB per vCore
-布建高達 168 GB- Provision up to 168 GB
Gen5Gen5 佈建計算Provisioned compute
-Intel® E5-2673 v4 (Broadwell) 2.3-GHz、Intel® SP-8160 (Skylake) * 和 intel® 8272CL (Cascade Lake) 2.5 GHz * 處理器- Intel® E5-2673 v4 (Broadwell) 2.3-GHz, Intel® SP-8160 (Skylake)*, and Intel® 8272CL (Cascade Lake) 2.5 GHz* processors
-布建高達80虛擬核心 (1 vCore = 1 超執行緒) - Provision up to 80 vCores (1 vCore = 1 hyper-thread)

無伺服器計算Serverless compute
-Intel® E5-2673 v4 (Broadwell) 2.3-GHz 和 Intel® SP-8160 (Skylake) * 處理器- Intel® E5-2673 v4 (Broadwell) 2.3-GHz and Intel® SP-8160 (Skylake)* processors
-自動擴大至40虛擬核心 (1 vCore = 1 超執行緒) - Auto-scale up to 40 vCores (1 vCore = 1 hyper-thread)
佈建計算Provisioned compute
-每個 vCore 5.1 GB- 5.1 GB per vCore
-布建高達 408 GB- Provision up to 408 GB

無伺服器計算Serverless compute
-自動調整為每個 vCore 24 GB- Auto-scale up to 24 GB per vCore
-自動調整高達 120 GB 上限- Auto-scale up to 120 GB max
Fsv2 系列Fsv2-series -Intel® 8168 (Skylake) 處理器- Intel® 8168 (Skylake) processors
-採用最大的核心 turbo 頻率速度 3.4 GHz,以及最大單一核心 turbo 頻率速度 3.7 g h z。- Featuring a sustained all core turbo clock speed of 3.4 GHz and a maximum single core turbo clock speed of 3.7 GHz.
-布建高達72虛擬核心 (1 vCore = 1 超執行緒) - Provision up to 72 vCores (1 vCore = 1 hyper-thread)
-每個 vCore 1.9 GB- 1.9 GB per vCore
-布建高達 136 GB- Provision up to 136 GB
M 系列M-series -Intel® E7-8890 v3 2.5 GHz 和 Intel® 8280M 2.7 GHz (Cascade Lake) 處理器- Intel® E7-8890 v3 2.5 GHz and Intel® 8280M 2.7 GHz (Cascade Lake) processors
-布建高達128虛擬核心 (1 vCore = 1 超執行緒) - Provision up to 128 vCores (1 vCore = 1 hyper-thread)
-每個 vCore 29 GB- 29 GB per vCore
-布建高達 3.7 TB- Provision up to 3.7 TB

* 在 sys.dm_user_db_resource_governance 動態管理檢視中,使用 INTEL® SP-8160 (Skylake) 處理器之資料庫的硬體世代會顯示為 Gen6,而使用 INTEL® 8272CL (Cascade Lake) 的資料庫產生硬體時,會顯示為 Gen7。* In the sys.dm_user_db_resource_governance dynamic management view, hardware generation for databases using Intel® SP-8160 (Skylake) processors appears as Gen6, while hardware generation for databases using Intel® 8272CL (Cascade Lake) appears as Gen7. 無論處理器類型 (Broadwell、Skylake 或 Cascade Lake) ,所有第5代資料庫的資源限制都相同。Resource limits for all Gen5 databases are the same regardless of processor type (Broadwell, Skylake, or Cascade Lake).

如需資源限制的詳細資訊,請參閱 單一資料庫的資源限制 (vCore) ,或彈性集區 的資源限制 (vCore) For more information on resource limits, see Resource limits for single databases (vCore), or Resource limits for elastic pools (vCore).

選取硬體世代Selecting a hardware generation

在 Azure 入口網站中,您可以在建立時選取 SQL Database 資料庫或集區的硬體世代,也可以變更現有資料庫或集區的硬體世代。In the Azure portal, you can select the hardware generation for a database or pool in SQL Database at the time of creation, or you can change the hardware generation of an existing database or pool.

若要在建立 SQL Database 或集區時選取硬體世代To select a hardware generation when creating a SQL Database or pool

如需詳細資訊,請參閱 建立 SQL DatabaseFor detailed information, see Create a SQL Database.

在 [ 基本 ] 索引標籤上,選取 [ 計算 + 儲存體 ] 區段中的 [ 設定資料庫 ] 連結,然後選取 [ 變更 設定] 連結:On the Basics tab, select the Configure database link in the Compute + storage section, and then select the Change configuration link:

設定資料庫

選取所需的硬體世代:Select the desired hardware generation:

選取硬體

變更現有 SQL Database 或集區的硬體世代To change the hardware generation of an existing SQL Database or pool

針對資料庫,請在 [總覽] 頁面上選取 [ 定價層 ] 連結:For a database, on the Overview page, select the Pricing tier link:

變更硬體

針對集區,請在 [總覽] 頁面上選取 [ 設定 ]。For a pool, on the Overview page, select Configure .

依照步驟來變更設定,然後選取硬體世代(如先前步驟中所述)。Follow the steps to change configuration, and select the hardware generation as described in the previous steps.

若要在建立 SQL 受控執行個體時選取硬體世代To select a hardware generation when creating a SQL Managed Instance

如需詳細資訊,請參閱 建立 SQL 受控執行個體For detailed information, see Create a SQL Managed Instance.

在 [ 基本 ] 索引標籤上,選取 [ 計算 + 儲存體 ] 區段中的 [ 設定資料庫 ] 連結,然後選取所需的硬體世代:On the Basics tab, select the Configure database link in the Compute + storage section, and then select desired hardware generation:

設定 SQL 受控執行個體

變更現有 SQL 受控執行個體的硬體世代To change the hardware generation of an existing SQL Managed Instance

從 [SQL 受控執行個體] 頁面的 [設定] 區段下,選取 [ 定價層 ] 連結From the SQL Managed Instance page, select Pricing tier link placed under the Settings section

變更 SQL 受控執行個體硬體

在 [定價層] 頁面上,您將能夠如先前步驟中所述變更硬體世代。On the Pricing tier page, you will be able to change hardware generation as described in the previous steps.

硬體可用性Hardware availability

第4代/第5代Gen4/Gen5

第4代硬體即將 推出 ,且不再適用于新的部署。Gen4 hardware is being phased out and is no longer available for new deployments. 所有新的資料庫都必須部署在第5代硬體上。All new databases must be deployed on Gen5 hardware.

全球大部分區域都有提供第5代。Gen5 is available in most regions worldwide.

Fsv2 系列Fsv2-series

Fsv2 系列適用于下欄區域:澳大利亞中部、澳大利亞中部2、澳大利亞東部、澳大利亞東南部、巴西南部、加拿大中部、東亞、美國東部、法國中部、印度中部、韓國中部、南韓南部、歐洲北部、南非北部、東南亞、英國南部、英國西部、西歐、美國西部2。Fsv2-series is available in the following regions: Australia Central, Australia Central 2, Australia East, Australia Southeast, Brazil South, Canada Central, East Asia, East Us, France Central, India Central, Korea Central, Korea South, North Europe, South Africa North, Southeast Asia, UK South, UK West, West Europe, West Us 2.

M 系列M-series

M 系列適用于下欄區域:美國東部、北歐、西歐、美國西部2。M-series is available in the following regions: East US, North Europe, West Europe, West US 2.

後續步驟Next steps

若要開始使用,請參閱:To get started, see:

如需定價詳細資料,請參閱 Azure SQL Database 定價頁面For pricing details, see the Azure SQL Database pricing page.

如需一般用途和業務關鍵服務層級中可用的特定計算和儲存體大小的詳細資訊,請參閱:For details about the specific compute and storage sizes available in the general purpose and business critical service tiers, see: