SQL Server 2016 的各版本和支持的功能Editions and supported features of SQL Server 2016

适用对象:是SQL Server 否Azure SQL 数据库 否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.

可在 180 天的试用期内使用 SQL Server 评估版。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!

从评估中心下载 从评估中心下载 SQL Server 2016Download from Evaluation Center Download SQL Server 2016 from the Evaluation Center

Azure 虚拟机小启动已安装 SQL Server 2016 的虚拟机Azure 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 版提供了全面的高端数据中心功能,性能极为快捷、虚拟化不受限制,还具有端到端的商业智能,可为关键任务工作负荷提供较高服务级别,支持最终用户访问深层数据。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 版提供了基本数据管理和商业智能数据库,使部门和小型组织能够顺利运行其应用程序并支持将常用开发工具用于内部部署和云部署,有助于以最少的 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 对于 Web 主机托管服务提供商和 Web VAP 而言,SQL ServerSQL Server Web 版本是一项总拥有成本较低的选择,它可针对从小规模到大规模 Web 资产等内容提供可伸缩性、经济性和可管理性能力。SQL ServerSQL Server 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 版支持开发人员基于 SQL ServerSQL Server构建任意类型的应用程序。Developer edition lets developers build any kind of application on top of SQL ServerSQL Server. 它包括 Enterprise 版的所有功能,但有许可限制,只能用作开发和测试系统,而不能用作生产服务器。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 版本是入门级的免费数据库,是学习和构建桌面及小型服务器数据驱动应用程序的理想选择。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 的所有可编程性功能,但在用户模式下运行,还具有零配置快速安装和必备组件要求较少的特点。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 Server 用于 Internet 服务器Using SQL ServerSQL Server with an Internet Server

在 Internet 服务器(如运行 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 Server 用于客户端/服务器应用程序Using 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 描述Description
SQL Server 数据库引擎SQL Server Database Engine SQL Server 数据库引擎SQL Server Database Engine 包括 数据库引擎Database Engine、部分工具和 “数据库引擎服务”Data Quality Services (DQS) 服务器,其中引擎是用于存储、处理和保护数据、复制及全文搜索的核心服务,工具用于管理数据库分析集成中和可访问 Hadoop 及其他异类数据源的 Polybase 集成中的关系数据和 XML 数据。includes the 数据库引擎Database 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 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 ServicesIntegration ServicesIntegration Services(DQS) 组件。It also includes the “数据库引擎服务”Data 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 来管理任何领域(产品、客户、帐户);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 描述Description
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 Engine 实例或 Analysis ServicesAnalysis Services实例。provides a graphical user interface to monitor an instance of the 数据库引擎Database Engine or Analysis ServicesAnalysis Services.
数据库引擎Database Engine 优化顾问Tuning Advisor 数据库引擎Database Engine 优化顾问可以协助创建索引、索引视图和分区的最佳组合。Tuning Advisor helps create optimal sets of indexes, indexed views, and partitions.
数据质量客户端Data 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 描述Description
SQL ServerSQL Server 联机丛书Books Online SQL ServerSQL Server的核心文档。Core documentation for SQL ServerSQL Server.

开发人员版和评估版Developer and Evaluation Editions
有关开发人员版和评估版支持的功能,请参阅下表中列出的 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.

开发人员版仍然仅支持一个 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 数据库引擎SQL Server Database Engine1Maximum compute capacity used by a single instance - SQL Server 数据库引擎SQL 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 数据库引擎SQL Server Database Engine实例的缓冲池的最大内存Maximum memory for buffer pool per instance of SQL Server 数据库引擎SQL Server Database Engine 操作系统支持的最大值Operating System Maximum 128 GB128 GB 64 GB64 GB 1410 MB1410 MB 1410 MB1410 MB
每个 SQL Server 数据库引擎SQL Server Database Engine实例的列存储段缓存的最大内存Maximum memory for Columnstore segment cache per instance of SQL Server 数据库引擎SQL Server Database Engine 不受限制的内存Unlimited memory 32 GB232 GB2 16 GB216 GB2 352 MB2352 MB2 352 MB2352 MB2
SQL Server 数据库引擎SQL Server Database Engine 中每个数据库的最大内存优化数据大小Maximum memory-optimized data size per database in SQL Server 数据库引擎SQL 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/AN/A N/AN/A N/AN/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/AN/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 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
Microsoft 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 GovernorResource Governor Yes No No No No
已分区表并行度Partitioned Table Parallelism Yes No No No No
多个 Filestream 容器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. 对于 Standard Edition,索引生成的进程并行度 (DOP) 限制为 2 DOP,对于 Web 和 Express Edition,索引生成的进程并行度 (DOP) 限制为 1 DOP。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 SQL Server Standard Edition 和基于 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 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
Distributed Replay - 客户端Distribute Replay - Client Yes Yes Yes No No
分布式重播 - 控制器Distributed 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 代理SQL Server Agent Yes Yes Yes No No
Microsoft System Center Operations Manager 管理包Microsoft System Center Operations Manager Management Pack Yes Yes Yes No No
数据库优化顾问 (DTA)Database Tuning Advisor (DTA) Yes 2Yes 2 2Yes 2 No No

1 可以使用 SQL Server Standard 和 SQL Server Enterprise 版本探查 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 版本功能启用优化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 1, 2Yes 1, 2 1, 2Yes 1, 2 1, 2Yes 1, 2
PolyBase 头节点PolyBase head node Yes No No No No
JSONJSON Yes Yes Yes Yes Yes
查询存储Query Store Yes Yes Yes Yes Yes
临时Temporal Yes Yes Yes Yes Yes
公共语言运行时 (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 具有多个计算节点的 Scale out 需要一个头节点。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
在无需数据库的情况下创建多维数据集Create 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 客户端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
平面和大地测量数据类型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 Assistant Yes Yes Yes Yes Yes
数据库邮件Database 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 EditionStreamInsight Premium Edition StreamInsight Standard EditionStreamInsight Standard Edition StreamInsight Standard EditionStreamInsight Standard Edition No No
StreamInsight HAStreamInsight HA StreamInsight Premium EditionStreamInsight 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 ServerInstallation for SQL Server