SQL Server 2016 的版本及支援功能Editions and supported features of SQL Server 2016

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

本主題提供 SQL Server 版本所支援功能的詳細資料。This topic provides details of features supported by the SQL Server editions. 此時,SQL Server 2017 各版本所支援的功能沒有任何變更。At this time, there are no changes to features supported by editions for SQL Server 2017.

安裝需求根據應用程式的需要而異。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.

SQL Server Evaluation Edition 提供了 180 天的試用期。The SQL Server Evaluation edition is available for a 180-day trial period.

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

試用 SQL Server!Try SQL Server!

從 Evaluation Center 下載 從 Evaluation Center 下載 SQL Server 2016Download from Evaluation Center Download SQL Server 2016 from the Evaluation Center

Azure Virtual Machine small Spin up a Virtual Machine with SQL Server 2016 already installedAzure Virtual Machine small Spin up a Virtual Machine with SQL Server 2016 already installed

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 Edition 這套頂級供應項目不但提供完整的高階資料中心功能,而且具備急速效能、不受限制的虛擬化,以及端對端商業智慧 - 為任務關鍵性工作負載提供最高的服務等級,並讓終端使用者獲得資料洞察能力。The premium offering, SQL ServerSQL Server Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization, and end-to-end business intelligence - enabling high service levels for mission-critical workloads and end-user access to data insights.
StandardStandard SQL ServerSQL Server Standard Edition 針對部門和小型組織提供基本的資料管理與商業智慧資料庫來執行應用程式,並且支援內部部署和雲端的一般開發工具 - 以最少的 IT 資源提供最有效率的資料庫管理。Standard edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premise 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.
DeveloperDeveloper 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 對於建置 SQL ServerSQL Server 和測試應用程式的人員來說是理想的選擇。Developer is an ideal choice for people who build SQL ServerSQL Server and test applications.
Express 版本Express editions 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 Server Express LocalDB 是輕量版的 Express,其中包含所有程式設計功能,但卻可以使用者模式執行,並配備快速的零設定安裝,而且所需的必要條件很少。Express LocalDB, a lightweight version of Express that has all of its programmability features, yet runs in user mode, and has a fast, zero-configuration installation and a short list of prerequisites.

搭配網際網路伺服器使用 SQL ServerSQL ServerUsing SQL ServerSQL Server with an Internet Server

在網際網路伺服器中,例如執行 Internet Information Services (IIS) 的伺服器,您通常會安裝 SQL ServerSQL Server 用戶端工具。On an Internet server, such as a server that is running Internet Information Services (IIS), you will typically install the SQL ServerSQL Server client tools. 用戶端工具包括連接到 SQL ServerSQL Server執行個體的應用程式所使用的用戶端連接元件。Client tools include the client connectivity components used by an application connecting to an instance of SQL ServerSQL Server.

注意

雖然您可以在執行 IIS 的電腦上安裝 SQL ServerSQL Server 的執行個體,但通常只會對具有單一伺服器電腦的小型網站這樣做。Although you can install an instance of SQL ServerSQL Server on a computer that is running IIS, this is typically done only for small web sites that have a single server computer. 大部分網站會將它們的中介層 IIS 系統放在一部伺服器或伺服器叢集上,並將其資料庫放在另一部伺服器或伺服器聯盟上。Most Web sites have their middle-tier IIS systems on one server or a cluster of servers, and their databases on a separate server or federation of servers.

搭配用戶端/伺服器應用程式使用 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 功能:回溯相容性元件、 SQL Server Data ToolsSQL Server Data Tools、連接元件、管理工具、軟體開發套件和《 SQL ServerSQL Server 線上叢書》元件。The client tools option installs the following SQL ServerSQL Server features: backward compatibility components, SQL Server Data ToolsSQL Server Data Tools, connectivity components, management tools, software development kit, and SQL ServerSQL Server Books Online components. 如需詳細資訊,請參閱安裝 SQL ServerFor more information, see Install SQL Server.

SQL ServerSQL Server 元件之間作決定Deciding Among SQL ServerSQL Server Components

使用 SQL ServerSQL Server 安裝精靈的 [特徵選取] 頁面來選取要併入 SQL ServerSQL Server安裝的元件。Use the Feature Selection page of the SQL ServerSQL Server Installation Wizard to select the components to include in an installation of SQL ServerSQL Server. 依預設,不會選取樹狀結構中的任何功能。By default, none of the features in the tree are selected.

請使用下表中的資訊來判斷最符合您需求的功能集。Use the information in the following tables to determine the set of features that best fits your needs.

伺服器元件Server components DescriptionDescription
SQL Server Database EngineSQL Server Database Engine SQL Server Database EngineSQL Server Database Engine 包含 Database EngineDatabase Engine,這是適用於儲存、處理和保護資料;複寫;全文檢索搜尋;管理關聯式和 XML 資料用的工具;資料庫內分析整合,以及適用於存取 Hadoop 與其他異質資料來源的 PolyBase 整合,以及 Data Quality ServicesData Quality Services (DQS) 伺服器的核心服務。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, in database analytics integration, and PolyBase integration for access to Hadoop and other heterogeneous data sources, and the Data Quality ServicesData Quality Services (DQS) server.
Analysis ServicesAnalysis Services Analysis ServicesAnalysis Services 包括用來建立及管理線上分析處理 (OLAP) 和資料採礦應用程式的工具。includes the tools for creating and managing online analytical processing (OLAP) and data mining applications.
Reporting ServicesReporting Services Reporting ServicesReporting Services 包括伺服器和用戶端元件,可用來建立、管理和部署表格式、矩陣、圖形化和自由形式報表。includes server and client components for creating, managing, and deploying tabular, matrix, graphical, and free-form reports. Reporting ServicesReporting Services 也是一個可延伸的平台,可讓您用來開發報表應用程式。is also an extensible platform that you can use to develop report applications.
Integration ServicesIntegration Services Integration ServicesIntegration Services 是一組圖形化工具和可程式化物件,用來移動、複製和轉換資料。is a set of graphical tools and programmable objects for moving, copying, and transforming data. 其中還包括 Data Quality ServicesData Quality ServicesIntegration ServicesIntegration Services(DQS) 元件。It also includes the Data Quality ServicesData Quality Services (DQS) component for Integration ServicesIntegration Services.
Master Data ServicesMaster Data Services Master Data ServicesMaster Data Services (MDS) 是用於主要資料管理的 SQL ServerSQL Server 方案。(MDS) is the SQL ServerSQL Server solution for master data management. MDS 可設定為管理任何網域 (產品、客戶、帳戶) 而且包括階層、更細微的安全性、交易、資料版本控制和商務規則,以及可用來管理資料的 適用於 Excel 的增益集Add-in for ExcelMDS can be configured to manage any domain (products, customers, accounts) and includes hierarchies, granular security, transactions, data versioning, and business rules, as well as an 適用於 Excel 的增益集Add-in for Excel that can be used to manage data.
R Services (資料庫內)R Services (In-Database) R Services (資料庫內)R Services (In-Database) 支援多種平台上的分散式可調整 R 解決方案,且使用多種企業資料來源,包括 Linux、Hadoop 和 Teradata。supports distributed, scalable R solutions on multiple platforms and using multiple enterprise data sources, including Linux, Hadoop, and Teradata.
管理工具Management tools DescriptionDescription
SQL Server Management StudioSQL Server Management Studio SQL Server Management StudioSQL Server Management Studio 是一個整合式環境,可存取、設定、管理及開發 SQL ServerSQL Server的元件。is an integrated environment to access, configure, manage, administer, and develop components of SQL ServerSQL Server. Management StudioManagement Studio 可讓所有技能等級的開發人員和管理員使用 SQL ServerSQL Serverlets developers and administrators of all skill levels use SQL ServerSQL Server.

下載並安裝Download and install
Management StudioManagement Studio 下載 SQL Server Management Studio from Download SQL Server Management Studio
SQL ServerSQL Server 組態管理員Configuration Manager SQL ServerSQL Server 組態管理員對 SQL ServerSQL Server 服務、伺服器通訊協定、用戶端通訊協定和用戶端別名提供基本組態管理。Configuration Manager provides basic configuration management for SQL ServerSQL Server services, server protocols, client protocols, and client aliases.
SQL Server ProfilerSQL Server Profiler SQL Server ProfilerSQL Server Profiler 提供圖形化使用者介面來監視 Database EngineDatabase EngineAnalysis ServicesAnalysis Services的執行個體。provides a graphical user interface to monitor an instance of the Database EngineDatabase Engine or Analysis ServicesAnalysis Services.
Database EngineDatabase Engine Tuning AdvisorTuning Advisor Database EngineDatabase Engine Tuning Advisor 協助您建立一組最佳的索引、索引檢視表和分割區。Tuning Advisor helps create optimal sets of indexes, indexed views, and partitions.
Data Quality ClientData Quality Client 提供相當簡單且高度直覺式的圖形使用者介面來連接 DQS 伺服器,以及執行資料清除作業。Provides a highly simple and intuitive graphical user interface to connect to the DQS server, and perform data cleansing operations. 此外還可讓您集中監控資料清除作業期間執行的各種活動。It also allows you to centrally monitor various activities performed during the data cleansing operation.
SQL Server Data ToolsSQL Server Data Tools SQL Server Data ToolsSQL Server Data Tools 提供 IDE,可用來為下列商業智慧元件建立方案: Analysis ServicesAnalysis ServicesReporting ServicesReporting ServicesIntegration ServicesIntegration Servicesprovides an IDE for building solutions for the Business Intelligence components: Analysis ServicesAnalysis Services, Reporting ServicesReporting Services, and Integration ServicesIntegration Services.

(先前稱為 Business Intelligence Development Studio)。(Formerly called Business Intelligence Development Studio).

SQL Server Data ToolsSQL Server Data Tools 也包含「資料庫專案」,為資料庫開發人員提供整合環境,以實現 Visual Studio 內任何 SQL ServerSQL Server 平台 (內部和外部部署) 適用的所有資料庫設計工作。also includes "Database Projects", which provides an integrated environment for database developers to carry out all their database design work for any SQL ServerSQL Server platform (both on and off premise) within Visual Studio. 資料庫開發人員可以使用 Visual Studio 中的增強伺服器總管,輕鬆建立或編輯資料庫物件和資料,或執行查詢。Database developers can use the enhanced Server Explorer in Visual Studio to easily create or edit database objects and data, or execute queries.
連接元件Connectivity Components 安裝用於用戶端和伺服器之間通訊的元件以及用於 DB-Library、ODBC 和 OLE DB 的網路程式庫。Installs components for communication between clients and servers, and network libraries for DB-Library, ODBC, and OLE DB.
文件集Documentation DescriptionDescription
SQL ServerSQL Server 線上叢書Books Online SQL ServerSQL Server的核心文件集。Core documentation for SQL ServerSQL Server.

Developer 和 Evaluation 版本Developer and Evaluation Editions
如需 Developer 和 Evaluation 版本所支援的功能,請參閱下列各表中針對 SQL Server Enterprise Edition 列出的功能。For features supported by Developer and Evaluation editions, see features listed for the SQL Server Enterprise Edition in the tables below.

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

Scale LimitsScale Limits

功能Feature EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services 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 限制為 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 限制為 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 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 GB232 GB2 16 GB216 GB2 352 MB2352 MB2 352 MB2352 MB2
每個 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 GB232 GB2 16 GB216 GB2 352 MB2352 MB2 352 MB2352 MB2
每個 Analysis ServicesAnalysis Services執行個體使用的記憶體上限Maximum memory utilized per instance of Analysis ServicesAnalysis Services 作業系統最大值Operating System Maximum 表格式:16 GBTabular: 16 GB

MOLAP:64 GBMOLAP: 64 GB
不適用N/A 不適用N/A 不適用N/A
每個 Reporting ServicesReporting Services執行個體使用的記憶體上限Maximum memory utilized per instance of Reporting ServicesReporting Services 作業系統最大值Operating System Maximum 64 GB64 GB 64 GB64 GB 4 GB4 GB 不適用N/A
關聯式資料庫大小上限Maximum relational database size 524 PB524 PB 524 PB524 PB 524 PB524 PB 10 GB10 GB 10 GB10 GB

1 新合約不適用的 Enterprise Edition (含伺服器 + 用戶端存取授權 (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. 如需詳細資訊,請參閱 Compute Capacity Limits by Edition of SQL ServerFor more information, see Compute Capacity Limits by Edition of SQL Server.

2 在跨版本建立常見程式設計介面區 (CPSA) 的過程中,套用至 SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1。2 Applies to SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1 as part of creating a common programmability surface area (CPSA) across editions.

RDBMS High AvailabilityRDBMS High Availability

功能Feature EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services ExpressExpress
Server Core 支援 1Server core support 1 Yes Yes Yes Yes Yes
記錄傳送Log shipping Yes Yes Yes No No
資料庫鏡像Database mirroring Yes Yes

僅限 FULL 安全性Full safety only
僅限見證Witness only 僅限見證Witness only 僅限見證Witness only
備份壓縮Backup compression Yes Yes No No No
資料庫快照集Database snapshot Yes 3Yes 3 3Yes 3 3Yes 3 3Yes 3
AlwaysOn 容錯移轉叢集執行個體Always On failover cluster instances Yes

1616
Yes

支援 2 個節點Support for 2 nodes
No No No
AlwaysOn 可用性群組Always On availability groups Yes

最多 8 個次要複本,包括 2 個同步次要複本。Up to 8 secondary replicas, including 2 synchronous secondary replicas
No No No No
基本可用性群組 2Basic availability groups 2 No Yes

支援 2 個節點Support for 2 nodes
No No No
線上頁面和檔案還原Online page and file restore Yes No No No No
線上檢索索引Online indexing Yes No No No No
線上結構描述變更Online schema change Yes No No No No
快速復原Fast recovery Yes No No No No
鏡像備份Mirrored backups Yes No No No No
熱新增記憶體和 CPUHot add memory and CPU Yes No No No No
資料庫復原建議程式Database recovery advisor Yes Yes Yes Yes Yes
加密的備份Encrypted backup Yes Yes No No No
混合式備份至 Windows Azure (備份至 URL)Hybrid backup to Windows Azure (backup to URL) Yes Yes No No No

1如需在 Server Core 上安裝 SQL Server 的詳細資訊,請參閱在 Server Core 上安裝 SQL Server1 For more information on installing SQL Server on Server Core, see Install SQL Server on Server Core.

2 如需基本可用性群組的詳細資訊,請參閱 基本可用性群組2 For more information about Basic availability groups, see Basic Availability Groups.

3 在跨版本建立常見程式設計介面區 (CPSA) 的過程中,套用至 SQL ServerSQL Server 2016 SP1。3 Applies to SQL ServerSQL Server 2016 SP1 as part of creating a common programmability surface area (CPSA) across editions.

RDBMS Scalability and PerformanceRDBMS Scalability and Performance

功能Feature EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services ExpressExpress
資料行存放區 1Columnstore 1 Yes 2Yes 2 2Yes 2 2Yes2 2Yes2
記憶體內部 OLTP 1In-Memory OLTP 1 Yes 2Yes 2 2Yes 2 23Yes 2, 3 2Yes 2
Stretch DatabaseStretch Database Yes Yes Yes Yes Yes
持續性的主記憶體Persistent Main Memory Yes Yes Yes Yes Yes
多個執行個體支援Multi-instance support 5050 5050 5050 5050 5050
資料表和索引分割區Table and index partitioning Yes 2Yes 2 2Yes 2 2Yes 2 2Yes 2
資料壓縮Data compression Yes 2Yes 2 2Yes 2 2Yes 2 2Yes 2
[資源管理員]Resource Governor Yes No No No No
分割資料表平行處理原則Partitioned Table Parallelism Yes No No No No
多個檔案資料流容器Multiple Filestream containers Yes 2Yes 2 2Yes 2 2Yes 2 2Yes 2
NUMA 感知大型分頁記憶體和緩衝區陣列配置NUMA Aware Large Page Memory and Buffer Array Allocation Yes 4No 4 No No No
緩衝集區擴充Buffer Pool Extension Yes Yes No No No
I/O 資源管理I/O Resource Governance Yes No No No No
預先讀取Read-Ahead Yes No No No No
進階掃描Advanced Scanning Yes No No No No
延遲持久性Delayed Durability Yes 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 Edition) 和 1 DOP (Web Edition 和 Express Edition)。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.

2 在跨版本建立常見程式設計介面區 (CPSA) 的過程中,套用至 SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1。2 Applies to SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1 as part of creating a Common Programmability Surface Area (CPSA) across editions.

3 這項功能不會納入 LocalDB 安裝選項。3 This feature is not included in the LocalDB installation option.

4 Standard Edition 與 SQL Server + CAL 型授權可以限制 SQL Server Standard 可使用的處理器數目,但 SQL Server Standard 是 NUMA 感知的。4 Standard Edition and SQL Server + CAL-based licensing can restrict how many processors SQL Server Standard can use, but SQL Server Standard is NUMA aware.

RDBMS SecurityRDBMS Security

功能Feature EnterpriseEnterprise StandardStandard WebWeb ExpressExpress Express with Advanced ServicesExpress with Advanced Services
資料列層級安全性Row-level security Yes Yes 1Yes 1 1Yes 1 1Yes 1
Always EncryptedAlways Encrypted Yes 1Yes 1 1Yes 1 1Yes 1 1Yes 1
動態資料遮罩Dynamic data masking Yes Yes 1Yes 1 1Yes 1 1Yes 1
基本稽核Basic auditing Yes Yes Yes Yes Yes
細部稽核Fine grained auditing Yes 1Yes 1 1Yes 1 1Yes 1 1Yes 1
透明資料庫加密Transparent database encryption Yes No No No No
可延伸金鑰管理Extensible key management Yes No No No No
使用者定義角色User-defined roles Yes Yes Yes Yes Yes
自主資料庫Contained databases Yes Yes Yes Yes Yes
備份的加密Encryption for backups Yes Yes No No No

1 在跨版本建立常見程式設計介面區 (CPSA) 的過程中,套用至 SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1。1 Applies to SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1 as part of creating a common programmability surface area (CPSA) across editions.

ReplicationReplication

功能Feature EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services ExpressExpress
異質性訂閱者Heterogeneous subscribers Yes Yes No No No
合併式複寫Merge replication Yes Yes 是 (僅限訂閱者)Yes (Subscriber only) 是 (僅限訂閱者)Yes (Subscriber only) 是 (僅限訂閱者)Yes (Subscriber only)
Oracle 發行Oracle publishing Yes No No No No
點對點異動複寫Peer to peer transactional replication Yes No No No No
快照式複寫Snapshot replication Yes Yes 是 (僅限訂閱者)Yes (Subscriber only) 是 (僅限訂閱者)Yes (Subscriber only) 是 (僅限訂閱者)Yes (Subscriber only)
SQL Server 變更追蹤SQL Server change tracking Yes Yes Yes Yes Yes
異動複寫Transactional replication Yes Yes 是 (僅限訂閱者)Yes (Subscriber only) 是 (僅限訂閱者)Yes (Subscriber only) 是 (僅限訂閱者)Yes (Subscriber only)
異動複寫至 AzureTransactional replication to Azure Yes Yes No No No
異動複寫可更新訂閱Transactional replication updateable subscription Yes No No No No

Management ToolsManagement Tools

功能Feature EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services ExpressExpress
SQL 管理物件 (SMO)SQL Management Objects (SMO) Yes Yes Yes Yes Yes
SQL 組態管理員SQL Configuration Manager Yes Yes Yes Yes Yes
SQL CMD (命令提示字元工具)SQL CMD (Command Prompt tool) Yes Yes Yes Yes Yes
Distributed Replay - 管理工具Distributed Replay - Admin Tool Yes Yes Yes Yes No
Distribute Replay - ClientDistribute Replay - Client Yes Yes Yes No No
Distributed Replay - ControllerDistributed Replay - Controller 是 (最多 16 個用戶端)Yes (Up to 16 clients) 是 (1 個用戶端)Yes (1 client) 是 (1 個用戶端)Yes (1 client) No No
SQL ProfilerSQL Profiler Yes Yes 1No 1 1No 1 1No 1
SQL Server AgentSQL Server Agent Yes Yes Yes No No
Microsoft System Center Operations Manager 管理組件Microsoft System Center Operations Manager Management Pack Yes Yes Yes No No
Database Tuning Advisor (DTA)Database Tuning Advisor (DTA) Yes 2Yes 2 2Yes 2 No No

1 您可以使用 SQL Server Standard 和 SQL Server Enterprise Edition 來分析 SQL Server Web、SQL Server Express、SQL Server Express with Tools 和 SQL Server Express with Advanced Services。1 SQL Server Web, SQL Server Express, SQL Server Express with Tools, and SQL Server Express with Advanced Services can be profiled using SQL Server Standard and SQL Server Enterprise editions.

2 僅針對 Standard Edition 功能啟用微調。2 Tuning enabled only on Standard edition features

RDBMS ManageabilityRDBMS Manageability

功能Feature EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services ExpressExpress
使用者執行個體User instances No No No Yes Yes
LocalDBLocalDB No No No Yes No
專用管理員連接Dedicated admin connection Yes Yes Yes 是,附追蹤旗標Yes with trace flag 是,附追蹤旗標Yes with trace flag
PowerShell 指令碼支援PowerShell scripting support Yes Yes Yes Yes Yes
SysPrep 支援 1SysPrep support 1 Yes Yes Yes Yes Yes
資料層應用程式元件作業的支援 - 擷取、部署、升級、刪除Support for data-tier application component operations - extract, deploy, upgrade, delete Yes Yes Yes Yes Yes
原則自動化 (依排程和變更檢查)Policy automation (check on schedule and change) Yes Yes Yes No No
效能資料收集器Performance data collector Yes Yes Yes No No
能夠在多重執行個體管理中註冊為受管理的執行個體Able to enroll as a managed instance in multi-instance management Yes Yes Yes No No
標準效能報告Standard performance reports Yes Yes Yes No No
計畫指南和計畫指南的計畫凍結Plan guides and plan freezing for plan guides Yes Yes Yes No No
索引檢視表的直接查詢 (使用 NOEXPAND 提示)Direct query of indexed views (using NOEXPAND hint) Yes Yes Yes Yes Yes
自動索引檢視表維護Automatic indexed views maintenance Yes Yes Yes No No
分散式分割區檢視Distributed partitioned views Yes No No No No
平行索引作業Parallel indexed operations Yes No No No No
查詢最佳化工具自動使用索引檢視表Automatic use of indexed view by query optimizer Yes No No No No
平行一致性檢查Parallel consistency check Yes No No No No
SQL Server 公用程式控制點SQL Server Utility Control Point Yes No No No No
緩衝集區延伸模組Buffer pool extension Yes Yes No No No

1 如需詳細資訊,請參閱 使用 SysPrep 安裝 SQL Server 的考量1 For more information, see Considerations for Installing SQL Server Using SysPrep.

2 在跨版本建立常見程式設計介面區 (CPSA) 的過程中,套用至 SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1。2 Applies to SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1 as part of creating a common programmability surface area (CPSA) across editions.

Development ToolsDevelopment Tools

功能Feature EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services ExpressExpress
Microsoft Visual Studio 整合Microsoft Visual Studio integration Yes Yes Yes Yes Yes
Intellisense (Transact-SQL 和 MDX)Intellisense (Transact-SQL and MDX) Yes Yes Yes Yes Yes
SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT) Yes Yes Yes Yes No
MDX 編輯、偵錯和設計工具MDX edit, debug, and design tools Yes Yes No No No

ProgrammabilityProgrammability

功能Feature EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services ExpressExpress
基本的 R 整合Basic R integration Yes Yes Yes Yes No
進階的 R 整合Advanced R integration Yes No No No No
R Server (Standalone)R Server (Standalone) Yes No No No No
PolyBase 計算節點PolyBase compute node Yes 1Yes 1 12Yes 1, 2 12Yes 1, 2 12Yes 1, 2
PolyBase 前端節點PolyBase head node Yes No No No No
JSONJSON Yes Yes Yes Yes Yes
查詢存放區Query Store Yes Yes Yes Yes Yes
TemporalTemporal Yes Yes Yes Yes Yes
Common Language Runtime (CLR) 整合Common Language Runtime (CLR) Integration Yes Yes Yes Yes Yes
原生 XML 支援Native XML support Yes Yes Yes Yes Yes
XML 索引XML indexing Yes Yes Yes Yes Yes
MERGE 與 UPSERT 功能MERGE & UPSERT capabilities Yes Yes Yes Yes Yes
FILESTREAM 支援FILESTREAM support Yes Yes Yes Yes Yes
FileTableFileTable Yes Yes Yes Yes Yes
日期和時間資料類型Date and Time datatypes Yes Yes Yes Yes Yes
國際化支援Internationalization support Yes Yes Yes Yes Yes
全文檢索和語意搜尋Full-text and semantic search Yes Yes Yes Yes No
查詢中的語言規格Specification of language in query Yes Yes Yes Yes No
Service Broker (訊息)Service Broker (messaging) Yes Yes 否 (僅限用戶端)No (Client only) 否 (僅限用戶端)No (Client only) 否 (僅限用戶端)No (Client only)
Transact-SQL 端點Transact-SQL endpoints Yes Yes Yes No No

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

2 在跨版本建立常見程式設計介面區 (CPSA) 的過程中,套用至 SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1。2 Applies to SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1 as part of creating a common programmability surface area (CPSA) across editions.

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.

Master Data ServicesMaster Data Services

如需 SQL ServerSQL Server 版本所支援之 Master Data ServicesMaster Data Services 和 Data Quality Services 功能的資訊,請參閱 SQL Server 版本支援的 Master Data Services 和 Data Quality Services 功能For information about the Master Data ServicesMaster Data Services and Data Quality Services features supported by the editions of SQL ServerSQL Server, see Master Data Services and Data Quality Services Features Supported by the Editions of SQL Server.

Data WarehouseData Warehouse

功能Feature EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services ExpressExpress
建立不含資料庫的 CubeCreate cubes without a database Yes Yes No No No
自動產生暫存和資料倉儲結構描述Autogenerate staging and data warehouse schema Yes Yes No No No
異動資料擷取Change data capture Yes 1Yes 1 No No No
星型聯結查詢最佳化Star join query optimizations Yes No No No No
可擴充的唯讀 Analysis Services 組態Scalable read-only Analysis Services configuration Yes No No No No
分割區資料表和索引上的查詢平行處理Parallel query processing on partitioned tables and indexes Yes No No No No
全域批次彙總Global batch aggregation Yes No No No No

1 在跨版本建立常見程式設計介面區 (CPSA) 的過程中,套用至 SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1。1 Applies to SQL Server 2016 (13.x)SQL Server 2016 (13.x) SP1 as part of creating a common programmability surface area (CPSA) across editions.

Analysis ServicesAnalysis Services

如需 SQL ServerSQL Server 版本所支援之 Analysis Services 功能的資訊,請參閱 SQL Server 版本支援的 Analysis Services 功能For information about the Analysis Services features supported by the editions of SQL ServerSQL Server, see Analysis Services Features Supported by the Editions of SQL Server.

BI Semantic Model (Multi Dimensional)BI Semantic Model (Multi Dimensional)

如需 SQL ServerSQL Server 版本所支援之 Analysis Services 功能的資訊,請參閱 SQL Server 版本支援的 Analysis Services 功能For information about the Analysis Services features supported by the editions of SQL ServerSQL Server, see Analysis Services Features Supported by the Editions of SQL Server.

BI Semantic Model (Tabular)BI Semantic Model (Tabular)

如需 SQL ServerSQL Server 版本所支援之 Analysis Services 功能的資訊,請參閱 SQL Server 版本支援的 Analysis Services 功能For information about the Analysis Services features supported by the editions of SQL ServerSQL Server, see Analysis Services Features Supported by the Editions of SQL Server.

Power Pivot for SharePointPower Pivot for SharePoint

如需 SQL ServerSQL Server 版本所支援之 Power Pivot for SharePoint 功能的資訊,請參閱 SQL Server 版本支援的 Analysis Services 功能For information about the Power Pivot for SharePoint features supported by the editions of SQL ServerSQL Server, see Analysis Services Features Supported by the Editions of SQL Server.

Data MiningData Mining

如需 SQL ServerSQL Server 版本所支援之資料採礦功能的資訊,請參閱 SQL Server 版本支援的 Analysis Services 功能For information about the Data Mining features supported by the editions of SQL ServerSQL Server, see Analysis Services Features Supported by the Editions of SQL Server.

Reporting ServicesReporting Services

如需 SQL ServerSQL Server 版本所支援之 Reporting Services 功能的資訊,請參閱 SQL Server 版本支援的 Reporting Services 功能For information about the Reporting Services features supported by the editions of SQL ServerSQL Server, see Reporting Services Features Supported by the Editions of SQL Server.

商業智慧用戶端Business Intelligence Clients

如需 SQL ServerSQL Server 版本所支援之商業智慧用戶端功能的資訊,請參閱 SQL Server 版本支援的 Analysis Services 功能SQL Server 版本支援的 Reporting Services 功能For information about the Business Intelligence Client features supported by the editions of SQL ServerSQL Server, see Analysis Services Features Supported by the Editions of SQL Server or Reporting Services Features Supported by the Editions of SQL Server.

Spatial and Location ServicesSpatial and Location Services

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

Additional Database ServicesAdditional Database Services

功能名稱Feature Name EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services ExpressExpress
SQL ServerSQL Server Migration AssistantMigration Assistant Yes Yes Yes Yes Yes
Database MailDatabase mail Yes Yes Yes No No

Other ComponentsOther Components

功能名稱Feature Name EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services ExpressExpress
StreamInsightStreamInsight StreamInsight Premium 版StreamInsight Premium Edition StreamInsight Standard 版StreamInsight Standard Edition StreamInsight Standard 版StreamInsight Standard Edition No No
StreamInsight HAStreamInsight HA StreamInsight Premium 版StreamInsight Premium Edition No No No No

Download SSMS Download the latest version of SQL Server Management StudioDownload SSMS Download the latest version of SQL Server Management Studio

另請參閱See Also

SQL Server 安裝Installation for SQL Server