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

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

本主题详细介绍 SQL Server 2017 的不同版本支持的功能。This topic provides details of features supported by the various editions of SQL Server 2017.

有关以前版本的信息,请参阅:For information about older versions, see:

根据应用程序的需要,安装要求会有所不同。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!

从 Evaluation Center 下载从 Evaluation Center 下载 SQL Server 2017Download from Evaluation Center Download SQL Server 2017 from the Evaluation Center

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 提供了全面的高端数据中心功能,性能极为快捷、无限虚拟化1,还具有端到端的商业智能,可为关键任务工作负荷提供较高服务级别并且支持最终用户访问数据见解。The premium offering, SQL ServerSQL Server Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization1 , 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 宿主和 Web VAP 来说,SQL ServerSQL Server 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 是构建和测试应用程序的人员的理想之选。Developer is an ideal choice for people who build 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 LocalDB is a lightweight version of Express that has all of its programmability features, runs in user mode and has a fast, zero-configuration installation and a short list of prerequisites.

1 Enterprise Edition 上提供有面向具有软件保障的客户的无限虚拟化。1 Unlimited virtualization is available on Enterprise Edition for customers with Software Assurance. 部署必须遵守许可指南Deployments must comply with the licensing guide. 有关详细信息,请参阅我们的定价和许可页For more information, see our Pricing and Licensing page.

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.
机器学习服务(数据库内)Machine Learning Services (In-Database) 机器学习服务(数据库内)支持使用企业数据源的分布式、可缩放的机器学习解决方案。Machine Learning Services (In-Database) supports distributed, scalable machine learning solutions using enterprise data sources. SQL Server 2016 支持 R 语言。In SQL Server 2016, the R language was supported. SQL Server 2017 支持 R 和 Python。SQL Server 2017 supports R and Python.
机器学习服务器(独立)Machine Learning Server (Standalone) 机器学习服务器(独立)支持在多个平台上部署分布式、可缩放机器学习解决方案,并可使用多个企业数据源,包括 Linux 和 Hadoop。Machine Learning Server (Standalone) supports deployment of distributed, scalable machine learning solutions on multiple platforms and using multiple enterprise data sources, including Linux and Hadoop. SQL Server 2016 支持 R 语言。In SQL Server 2016, the R language was supported. SQL Server 2017 支持 R 和 Python。SQL Server 2017 supports R and Python.
管理工具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 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 GB32 GB 16 GB16 GB 352 MB352 MB 352 MB352 MB
SQL Server 数据库引擎SQL Server Database Engine 中每个数据库的最大内存优化数据大小Maximum memory-optimized data size per database in SQL Server 数据库引擎SQL Server Database Engine 不受限制的内存Unlimited memory 32 GB32 GB 16 GB16 GB 352 MB352 MB 352 MB352 MB
每个 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.

RDBMS 高可用性RDBMS 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 Yes Yes Yes Yes
AlwaysOn 故障转移群集实例2Always On failover cluster instances2 Yes Yes No No No
AlwaysOn 可用性组3Always On availability groups3 Yes No No No No
基本可用性组4Basic availability groups 4 No Yes No No No
联机页面和文件还原Online page and file restore Yes No No No No
联机索引创建和重新生成Online index create and rebuild Yes No No No No
可恢复的联机索引重新生成Resumable online index rebuilds 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
读取缩放可用性组Read-scale availability group Yes Yes No No No No
最小副本提交可用性组Minimum replica commit availability group Yes 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 在 Enterprise 版本中,节点数是操作系统支持的最大值。2 On Enterprise Edition, the number of nodes is the operating system maximum. Standard 版本中支持两个节点。On Standard edition there is support for two nodes.

3 Enterprise 版本支持最多 8 个辅助副本,包括 2 个同步辅助副本。3 On Enterprise Edition, provides support for up to 8 secondary replicas - including 2 synchronous secondary replicas.

4 Standard 版本支持基本可用性组。4 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 StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services ExpressExpress
列存储 1Columnstore 1 Yes Yes Yes Yes Yes
聚集列存储索引中的大型对象二进制文件Large object binaries in clustered columnstore indexes Yes Yes Yes Yes Yes
联机非聚集列存储索引重新生成Online non-clustered columnstore index rebuild Yes No No No No
内存中 OLTP 1In-Memory OLTP 1 Yes Yes Yes 是,2Yes, 2 Yes
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 Yes Yes Yes Yes
数据压缩Data compression Yes Yes Yes Yes Yes
Resource GovernorResource Governor Yes No No No No
已分区表并行度Partitioned Table Parallelism Yes No No No No
多个 Filestream 容器Multiple Filestream containers Yes Yes Yes Yes Yes
可识别 NUMA 的大型页内存和缓冲区数组分配NUMA Aware Large Page Memory and Buffer Array Allocation Yes No 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
自动优化Automatic Tuning Yes No No No No
批处理模式自适应联接Batch Mode Adaptive Joins Yes No No No No
批处理模式内存授予反馈Batch Mode Memory Grant Feedback Yes No No No No
多语句表值函数的交错执行Interleaved Execution for Multi-Statement Table Valued Functions Yes Yes Yes Yes Yes
大容量插入改进Bulk insert improvements 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 LocalDB 安装选项中不包括此功能。2 This feature is not included in the LocalDB installation option.

RDBMS 安全性RDBMS security

功能Feature EnterpriseEnterprise StandardStandard WebWeb ExpressExpress Express with Advanced ServicesExpress with Advanced Services
行级安全性Row-level security Yes Yes Yes Yes Yes
始终加密Always Encrypted Yes Yes Yes Yes Yes
动态数据屏蔽Dynamic data masking Yes Yes Yes Yes Yes
基本审核Basic auditing Yes Yes Yes Yes Yes
精细审核Fine grained auditing Yes Yes Yes Yes Yes
透明数据库加密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

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 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 可管理性RDBMS 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
SysPrep 支持 1SysPrep support 1 Yes Yes Yes Yes Yes
PowerShell 脚本支持2PowerShell scripting support2 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在 Linux 上,支持来自于 Windows 计算机、面向 Linux 上的 SQL Server 的 PowerShell 脚本。2 On Linux, PowerShell scripts are supported, from Windows computers targeting SQL Servers on Linux.

开发工具Development 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 集成 1Basic R integration 1 Yes Yes Yes Yes No
高级 R 集成 2Advanced R integration 2 Yes No No No No
基本 Python 集成Basic Python integration Yes Yes Yes Yes No
高级 Python 集成Advanced Python integration Yes No No No No
机器学习服务器(独立)Machine Learning Server (Standalone) Yes No No No No
PolyBase 计算节点PolyBase compute node Yes 3Yes 3 3Yes 3 3Yes 3 3Yes 3
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
图形Graph Yes Yes Yes Yes Yes

1 基本集成仅限于 2 个核心和内存中数据集。1 Basic integration is limited to 2 cores and in-memory data sets.

2 高级集成可以使用所有用于并行处理任意大小(受硬件限制)数据集的可用核心。2 Advanced integration can use all available cores for parallel processing of data sets at any size subject to hardware limits.

3 具有多个计算节点的横向扩展需要一个头节点。3 Scale out with multiple compute nodes requires a head node.

Integration ServicesIntegration Services

有关 SQL ServerSQL Server 各个版本支持的 SQL Server Integration Services (SSIS) 功能的信息,请参阅 SQL Server 各个版本支持的 Integration Services 功能For info about SQL Server 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 warehouse

功能Feature EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services ExpressExpress
在无需数据库的情况下创建多维数据集Create cubes without a database Yes Yes No No No
自动生成临时和数据仓库架构Auto-generate staging and data warehouse schema Yes Yes No No No
变更数据捕获Change data capture Yes Yes 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

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 语义模型(多维)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 语义模型(表格)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 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 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 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 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

后续步骤Next steps

SQL Server 的产品规格 Product Specifications for SQL Server
安装 SQL ServerInstallation for SQL Server

info_tip 获取帮助Get Help

编辑内容 参与编辑 SQL 文档Contribute SQL documentation

你是否知道你可以自己编辑内容?Did you know that you could edit the content yourself? 这样做不仅可以改进我们的文档,还可以获得页面贡献者的殊荣。If you do so, not only will our documentation improve, but you'll also be credited as a contributor to the page.