Linux 上 SQL Server 2017 的版本及支援功能Editions and supported features of SQL Server 2017 on Linux

適用於: 是SQL Server (僅限 Linux) 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server (Linux only) noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

本文提供 Linux 上各種 SQL Server 2017 版本支援的功能詳細資料。This article provides details of features supported by the various editions of SQL Server 2017 on Linux. 如需 Windows 上 SQL Server 的版本和支援功能,請參閱 SQL Server 2017 - WindowsFor editions and supported features of SQL Server on Windows, see SQL Server 2017 - Windows.

安裝需求根據應用程式的需要而異。Installation requirements vary based on your application needs. 不同的 SQL ServerSQL Server 版本可配合組織和個人的獨特效能、執行階段和價格需求。The different editions of SQL ServerSQL Server accommodate the unique performance, runtime, and price requirements of organizations and individuals. 安裝的 SQL ServerSQL Server 元件也將取決於您的特定需求。The SQL ServerSQL Server components that you install also depend on your specific requirements. 下列章節幫助您了解如何在 SQL ServerSQL Server的可用版本和元件之間做出最好的選擇。The following sections help you understand how to make the best choice among the editions and components available in SQL ServerSQL Server.

如需最新版本資訊和新功能資訊,請參閱下列項目:For the latest release notes and what's new information, see the following:

如需 Linux 上無法使用的 SQL Server 功能清單,請參閱不支援的功能和服務For a list of SQL Server features not available on Linux, see Unsupported features and services.

試用 SQL Server!Try SQL Server!

下載 SQL Server 2017Download SQL Server 2017

SQL ServerSQL Server 版本editions

下表描述 SQL ServerSQL Server的版本。The following table describes the editions of SQL ServerSQL Server.

SQL ServerSQL Server 版本edition 定義Definition
EnterpriseEnterprise SQL ServerSQL Server Enterprise 版本這套頂級供應項目不但提供完整的高階資料中心功能且具備急速效能,可為任務關鍵性工作負載提供最高等級的服務。The premium offering, SQL ServerSQL Server Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance enabling high service levels for mission-critical workloads.
標準Standard SQL ServerSQL Server Standard 版本針對部門和小型組織提供基本的資料管理來執行應用程式,且支援內部部署和雲端的一般開發工具 - 以最少 IT 資源提供最有效的資料庫管理。Standard edition delivers basic data management for departments and small organizations to run their applications and supports common development tools for on-premises and cloud - enabling effective database management with minimal IT resources.
WebWeb SQL ServerSQL Server Web Edition 對於 Web 主控者和 Web VAP 而言是一個整體擁有成本很低的選擇,可針對小型到大型規模的 Web 屬性提供可擴充、負擔輕鬆而且管理方便的功能。Web edition is a low total-cost-of-ownership option for Web hosters and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large scale Web properties.
開發人員Developer SQL ServerSQL Server Developer Edition 可讓開發人員在 SQL ServerSQL Server上建立任何類型的應用程式。Developer edition lets developers build any kind of application on top of SQL ServerSQL Server. 其中包含 Enterprise Edition 的所有功能,但是只授權做為開發和測試系統使用,而不做為實際伺服器使用。It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. SQL ServerSQL Server Developer 是供應用程式建立和測試人員使用的理想選擇。Developer is an ideal choice for people who build and test applications.
Express 版本Express edition Express Edition 是入門級免費伺服器,非常適合用來學習及建置桌上型電腦和小型伺服器資料驅動應用程式。Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications. 這個版本是獨立軟體廠商、開發人員及建置用戶端應用程式之愛好者的最佳選擇。It is the best choice for independent software vendors, developers, and hobbyists building client applications. 如果您需要更進階的資料庫功能, SQL ServerSQL Server Express 可以順利地升級為其他更高階的 SQL ServerSQL Server版本。If you need more advanced database features, SQL ServerSQL Server Express can be seamlessly upgraded to other higher end versions of SQL ServerSQL Server.

搭配用戶端/伺服器應用程式使用 SQL ServerSQL ServerUsing SQL ServerSQL Server with client/server applications

您可以在執行用戶端/伺服器應用程式的電腦上只安裝 SQL ServerSQL Server 用戶端元件,這些應用程式會直接連接到 SQL ServerSQL Server的執行個體。You can install just the SQL ServerSQL Server client components on a computer that is running client/server applications that connect directly to an instance of SQL ServerSQL Server. 如果您要在資料庫伺服器上管理 SQL ServerSQL Server 的執行個體,或您打算開發 SQL ServerSQL Server 應用程式,則用戶端元件安裝也是一個不錯的選項。A client components installation is also a good option if you administer an instance of SQL ServerSQL Server on a database server, or if you plan to develop SQL ServerSQL Server applications.

SQL ServerSQL Server 元件components

Linux 上的 SQL Server 2017 支援 SQL Server 資料庫引擎。SQL Server 2017 on Linux supports the SQL Server database engine. 下表描述資料庫引擎的功能。The following table describes the features in the database engine.

伺服器元件Server components DescriptionDescription
SQL Server Database EngineSQL Server Database Engine SQL Server Database EngineSQL Server Database Engine 包含 Database EngineDatabase Engine (用來儲存、處理及保護資料安全的核心服務)、複寫、全文檢索搜尋功能、用來管理關聯式和 XML 資料的工具,以及資料庫內分析整合。includes the Database EngineDatabase Engine, the core service for storing, processing, and securing data, replication, full-text search, tools for managing relational and XML data, and in database analytics integration.

Developer、Enterprise Core 和 Evaluation 版本Developer, Enterprise Core, and Evaluation editions
如需 Developer、Enterprise Core 和 Evaluation 版本所支援的功能,請參閱下列表格中列出的 SQL Server Enterprise 版本功能。For features supported by Developer, Enterprise Core, and Evaluation editions, see features listed for the SQL Server Enterprise edition in the following tables.

Developer Edition 只持續支援一個 SQL Server Distributed Replay 用戶端。The Developer edition continues to support only one client for SQL Server Distributed Replay.

調整限制Scale limits

功能Feature EnterpriseEnterprise 標準Standard WebWeb ExpressExpress
單一執行個體所使用的計算容量上限 - SQL Server Database EngineSQL Server Database Engine1Maximum compute capacity used by a single instance - SQL Server Database EngineSQL Server Database Engine1 作業系統最大值Operating system maximum 限制為 4 個插槽或 24 個核心的較小者Limited to lesser of 4 sockets or 24 cores 限制為 4 個插槽或 16 個核心的較小者Limited to lesser of 4 sockets or 16 cores 限制為 1 個插槽或 4 個核心的較小者Limited to lesser of 1 socket or 4 cores
單一執行個體所使用的計算容量上限 - Analysis ServicesAnalysis ServicesReporting ServicesReporting ServicesMaximum compute capacity used by a single instance - Analysis ServicesAnalysis Services or Reporting ServicesReporting Services 作業系統最大值Operating system maximum 限制為 4 個插槽或 24 個核心的較小者Limited to lesser of 4 sockets or 24 cores 限制為 4 個插槽或 16 個核心的較小者Limited to lesser of 4 sockets or 16 cores 限制為 1 個插槽或 4 個核心的較小者Limited to lesser of 1 socket or 4 cores
每個 SQL Server Database EngineSQL Server Database Engine執行個體的緩衝集區記憶體上限Maximum memory for buffer pool per instance of SQL Server Database EngineSQL Server Database Engine 作業系統最大值Operating System Maximum 128 GB128 GB 64 GB64 GB 1410 MB1410 MB
每個 SQL Server Database EngineSQL Server Database Engine執行個體的資料行存放區區段快取記憶體上限Maximum memory for Columnstore segment cache per instance of SQL Server Database EngineSQL Server Database Engine 無限制的記憶體Unlimited memory 32 GB32 GB 16 GB16 GB 352 MB352 MB
每個 SQL Server Database EngineSQL Server Database Engine資料庫的記憶體最佳化資料大小上限Maximum memory-optimized data size per database in SQL Server Database EngineSQL Server Database Engine 無限制的記憶體Unlimited memory 32 GB32 GB 16 GB16 GB 352 MB352 MB
關聯式資料庫大小上限Maximum relational database size 524 PB524 PB 524 PB524 PB 524 PB524 PB 10 GB10 GB

1 新合約不適用的 Enterprise 版本 (含伺服器 + 用戶端存取使用權 (CAL)) 授權限制為每個 SQL Server 執行個體最多 20 個核心。1 Enterprise edition with Server + Client Access License (CAL) based licensing (not available for new agreements) is limited to a maximum of 20 cores per SQL Server instance. 核心伺服器授權模式之下沒有任何限制。There are no limits under the Core-based Server Licensing model. 如需詳細資訊,請參閱 SQL Server 版本的計算容量限制For more information, see Compute capacity limits by edition of SQL Server.

RDBMS 高可用性RDBMS high availability

功能Feature EnterpriseEnterprise 標準Standard WebWeb ExpressExpress
記錄傳送Log shipping Yes Yes Yes No
備份壓縮Backup compression Yes Yes No No
資料庫快照集Database snapshot Yes No No No
Always On 容錯移轉叢集執行個體1Always On failover cluster instance1 Yes Yes No No
Always On 可用性群組2Always On availability groups2 Yes No No No
基本可用性群組3Basic availability groups 3 No Yes No No
最小複本認可可用性群組Minimum replica commit availability group Yes Yes No No
無叢集的可用性群組Clusterless availability group Yes Yes No No
線上頁面和檔案還原Online page and file restore Yes No No No
線上檢索索引Online indexing Yes No No No
繼續線上索引重建Resumable online index rebuilds Yes No No No
線上結構描述變更Online schema change Yes No No No
快速復原Fast recovery Yes No No No
鏡像備份Mirrored backups Yes No No No
熱新增記憶體和 CPUHot add memory and CPU Yes No No No
加密的備份Encrypted backup Yes Yes No No
混合式備份至 Azure (備份至 URL)Hybrid backup to Azure (backup to URL) Yes Yes No No

1 在 Enterprise 版本上,節點數目是作業系統最大值。1 On Enterprise edition, the number of nodes is the operating system maximum. Standard Edition 支援兩個節點。On Standard edition, there is support for two nodes.

2 Enterprise 版本最多支援 8 個次要複本,包括 2 個同步次要複本。2 On Enterprise edition, provides support for up to 8 secondary replicas - including 2 synchronous secondary replicas.

3 Standard 版本支援基本可用性群組。3 Standard edition supports basic availability groups. 基本可用性群組支援兩個複本,使用一個資料庫。A basic availability group supports two replicas, with one database. 如需基本可用性群組的詳細資訊,請參閱基本可用性群組For more information about basic availability groups, see Basic Availability Groups.

RDBMS 延展性和效能RDBMS scalability and performance

功能Feature EnterpriseEnterprise 標準Standard WebWeb ExpressExpress
資料行存放區 1Columnstore 1 Yes Yes Yes Yes
叢集資料行存放區索引中的大型物件二進位檔Large object binaries in clustered columnstore indexes Yes Yes Yes Yes
線上非叢集資料行存放區索引重建Online nonclustered columnstore index rebuild Yes No No No
記憶體內部 OLTP 1In-Memory OLTP 1 Yes Yes Yes Yes
持續性的主記憶體Persistent Main Memory Yes Yes Yes Yes
資料表和索引分割區Table and index partitioning Yes Yes Yes Yes
資料壓縮Data compression Yes Yes Yes Yes
資源管理員Resource Governor Yes No No No
分割資料表平行處理原則Partitioned Table Parallelism Yes No No No
NUMA 感知大型分頁記憶體和緩衝區陣列配置NUMA Aware and Large Page Memory and Buffer Array Allocation Yes No No No
IO 資源管理IO Resource Governance Yes No No No
延遲持久性Delayed Durability Yes Yes Yes Yes
自動調整Automatic Tuning Yes No No No
批次模式自適性聯結Batch Mode Adaptive Joins Yes No No No
批次模式記憶體授與意見反應Batch Mode Memory Grant Feedback Yes No No No
交錯執行多重陳述式資料表值函式Interleaved Execution for Multi-Statement Table Valued Functions Yes Yes Yes Yes
大量插入增強功能Bulk insert improvements Yes Yes Yes Yes

1 記憶體內部 OLTP 資料大小和資料行存放區區段快取都限制為版本「縮放限制」區段指定的記憶體數量。1 In-Memory OLTP data size and Columnstore segment cache are limited to the amount of memory specified by edition in the Scale Limits section. 平行處理原則的最大程度是有限的。The max degrees of parallelism is limited. 索引建置的平行處理原則 (DOP) 程度限制為 2 DOP (Standard 版本) 和 1 DOP (Web 和 Express 版本)。The degrees of process parallelism (DOP) for an index build is limited to 2 DOP for the Standard edition and 1 DOP for the Web and Express editions. 這會參考以磁碟式資料表和記憶體最佳化資料表建立的資料行存放區索引。This refers to columnstore indexes created over disk-based tables and memory-optimized tables.

RDBMS 安全性RDBMS security

功能Feature EnterpriseEnterprise 標準Standard WebWeb ExpressExpress
資料列層級安全性Row-level security Yes Yes Yes Yes
永遠加密Always Encrypted Yes Yes Yes Yes
動態資料遮罩Dynamic data masking Yes Yes Yes Yes
基本稽核Basic auditing Yes Yes Yes Yes
細部稽核Fine grained auditing Yes Yes Yes Yes
透明資料庫加密Transparent database encryption Yes No No No
使用者定義角色User-defined roles Yes Yes Yes Yes
自主資料庫Contained databases Yes Yes Yes Yes
備份的加密Encryption for backups Yes Yes No No

RDBMS 管理能力RDBMS manageability

功能Feature EnterpriseEnterprise 標準Standard WebWeb ExpressExpress
專用管理員連接Dedicated admin connection Yes Yes Yes 是,附追蹤旗標Yes with trace flag
PowerShell 指令碼支援PowerShell scripting support Yes Yes Yes Yes
資料層應用程式元件作業的支援 - 擷取、部署、升級、刪除Support for data-tier application component operations - extract, deploy, upgrade, delete Yes Yes Yes Yes
原則自動化 (依排程和變更檢查)Policy automation (check on schedule and change) Yes Yes Yes No
效能資料收集器Performance data collector Yes Yes Yes No
標準效能報告Standard performance reports Yes Yes Yes No
計畫指南和計畫指南的計畫凍結Plan guides and plan freezing for plan guides Yes Yes Yes No
索引檢視表的直接查詢 (使用 NOEXPAND 提示)Direct query of indexed views (using NOEXPAND hint) Yes Yes Yes Yes
自動索引檢視表維護Automatic indexed views maintenance Yes Yes Yes No
分散式分割區檢視Distributed partitioned views Yes No No No
平行索引作業Parallel indexed operations Yes No No No
查詢最佳化工具自動使用索引檢視表Automatic use of indexed view by query optimizer Yes No No No
平行一致性檢查Parallel consistency check Yes No No No
SQL Server 公用程式控制點SQL Server Utility Control Point Yes No No No

ProgrammabilityProgrammability

功能Feature EnterpriseEnterprise 標準Standard WebWeb ExpressExpress
JSONJSON Yes Yes Yes Yes
查詢存放區Query Store Yes Yes Yes Yes
TemporalTemporal Yes Yes Yes Yes
原生 XML 支援Native XML support Yes Yes Yes Yes
XML 索引XML indexing Yes Yes Yes Yes
MERGE 與 UPSERT 功能MERGE & UPSERT capabilities Yes Yes Yes Yes
日期和時間資料類型Date and Time datatypes Yes Yes Yes Yes
國際化支援Internationalization support Yes Yes Yes Yes
全文檢索和語意搜尋Full-text and semantic search Yes Yes Yes Yes
查詢中的語言規格Specification of language in query Yes Yes Yes Yes
Service Broker (訊息)Service Broker (messaging) Yes Yes 否 (僅限用戶端)No (Client only) 否 (僅限用戶端)No (Client only)
Transact-SQL 端點Transact-SQL endpoints Yes Yes Yes No
圖表Graph Yes Yes Yes Yes

1 使用多個運算節點向外延展時需要標題節點。1 Scale out with multiple compute nodes requires a head node.

Integration ServicesIntegration Services

如需 SQL ServerSQL Server 版本支援的 Integration Services (SSIS) 功能資訊,請參閱 SQL Server 版本支援的 Integration Services 功能For info about the Integration Services (SSIS) features supported by the editions of SQL ServerSQL Server, see Integration Services features supported by the editions of SQL Server.

空間和定位服務Spatial and location services

功能名稱Feature Name EnterpriseEnterprise 標準Standard WebWeb ExpressExpress
空間索引Spatial indexes Yes Yes Yes Yes
平面與 Geodetic 資料類型Planar and geodetic datatypes Yes Yes Yes Yes
進階空間程式庫Advanced spatial libraries Yes Yes Yes Yes
匯入/匯出業界標準空間資料格式Import/export of industry-standard spatial data formats Yes Yes Yes Yes

不支援的功能與服務Unsupported features & services

Linux 上的 SQL Server 2017 不支援下列功能和服務。The following features and services are not available SQL Server 2017 on Linux. 這些功能的支援將隨著時間逐漸啟用。The support of these features will be increasingly enabled over time.

區域Area 不支援的功能或服務Unsupported feature or service
資料庫引擎Database engine 異動複寫Transactional replication
  合併式複寫Merge replication
  異動資料擷取 (請參閱 SQL Server Agent)Change Data Capture (see SQL Server Agent)
  Stretch DBStretch DB
  PolyBasePolyBase
  搭配協力廠商連線的分散式查詢Distributed query with 3rd-party connections
  連結至 SQL ServerSQL Server 以外之資料來源的連結伺服器Linked Servers to data sources other than SQL ServerSQL Server
  系統擴充預存程序 (XP_CMDSHELL 等)System extended stored procedures (XP_CMDSHELL, etc.)
  Filetable、FILESTREAMFiletable, FILESTREAM
  已設定 EXTERNAL_ACCESS 或 UNSAFE 權限的 CLR 組件CLR assemblies with the EXTERNAL_ACCESS or UNSAFE permission set
  緩衝集區擴充Buffer Pool Extension
SQL Server AgentSQL Server Agent 子系統:CmdExec、PowerShell、佇列讀取器、SSIS、SSAS、SSRSSubsystems: CmdExec, PowerShell, Queue Reader, SSIS, SSAS, SSRS
  警示Alerts
  記錄讀取器代理程式Log Reader Agent
  異動資料擷取 (CDC)Change Data Capture (CDC)
  受管理備份Managed Backup
高可用性High Availability 資料庫鏡像Database mirroring
安全性Security 可延伸金鑰管理Extensible Key Management
  適用於連結伺服器的 AD 驗證AD Authentication for Linked Servers
  適用於可用性群組 (AG) 的 AD 驗證AD Authentication for Availability Groups (AGs)
服務Services SQL Server BrowserSQL Server Browser
  SQL Server R ServicesSQL Server R services
  StreamInsightStreamInsight
  Analysis ServicesAnalysis Services
  Reporting ServicesReporting Services
  Data Quality ServicesData Quality Services
  Master Data ServicesMaster Data Services

後續步驟Next steps

SQL Server 2019 的版本及支援功能 - WindowsEditions and supported features for SQL Server 2019 - Windows
SQL Server 2017 的版本及支援功能 - WindowsEditions and supported features for SQL Server 2017 - Windows
SQL Server 2016 的版本及支援功能 - WindowsEditions and supported features for SQL Server 2016 - Windows
SQL Server 2014 的版本及支援功能 - WindowsEditions and supported features for SQL Server 2014 - Windows
SQL Server 安裝Installation for SQL Server
SQL Server 的產品規格Product Specifications for SQL Server