SQL Server 2019 (15.x)SQL Server 2019 (15.x) 的新增功能What's new in SQL Server 2019 (15.x)SQL Server 2019 (15.x)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions)

SQL Server 2019 (15.x)SQL Server 2019 (15.x) 在早期版本的基础上构建,旨在将 SQL Server 发展成一个平台,以提供开发语言、数据类型、本地或云环境以及操作系统选项。builds on previous releases to grow SQL Server as a platform that gives you choices of development languages, data types, on-premises or cloud environments, and operating systems.

本文总结了 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 的新功能和增强功能。This article summarizes the new features and enhancements for SQL Server 2019 (15.x)SQL Server 2019 (15.x).

有关详细信息和已知问题,请参阅 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 发行说明For more information and known issues, see SQL Server 2019 (15.x)SQL Server 2019 (15.x) release notes.

要获得 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 的最佳体验,请使用最新工具For the best experience with SQL Server 2019 (15.x)SQL Server 2019 (15.x), use the latest tools.

SQL Server 2019 (15.x)SQL Server 2019 (15.x) SQL ServerSQL Server 引入了 大数据群集Big Data Clustersintroduces 大数据群集Big Data Clusters for SQL ServerSQL Server. 它还为 SQL Server 数据库引擎、SQL Server Analysis Services、SQL Server 机器学习服务、Linux 上的 SQL Server 和 SQL Server Master Data Services 提供了附加功能和改进。It also provides additional capability and improvements for the SQL Server database engine, SQL Server Analysis Services, SQL Server Machine Learning Services, SQL Server on Linux, and SQL Server Master Data Services.

下面的一个 13 分钟的视频提供了对 SQL Server 2019 的介绍:The following video provides a 13-minute introduction into SQL Server 2019:

下面几个部分概述了这些功能。The following sections provide an overview of these features.

数据虚拟化和 SQL Server 2019 大数据群集SQL Server 2019 Big Data ClustersData virtualization and SQL Server 2019 大数据群集SQL Server 2019 Big Data Clusters

当代企业通常掌管着庞大的数据资产,这些数据资产由托管在整个公司的孤立数据源中的各种不断增长的数据集组成。Businesses today often preside over vast data estates consisting of a wide array of ever-growing data sets that are hosted in siloed data sources across the company. 利用 SQL Server 2019 大数据群集SQL Server 2019 Big Data Clusters,你可以从所有数据中获得近乎实时的见解,该群集提供了一个完整的环境来处理包括机器学习和 AI 功能在内的大量数据。Gain near real-time insights from all your data with SQL Server 2019 大数据群集SQL Server 2019 Big Data Clusters, which provide a complete environment for working with large sets of data, including machine learning and AI capabilities.

新增功能或更新New feature or update 详细信息Details
可缩放的大数据解决方案Scalable big data solution 部署 SQL Server、Spark 和在 Kubernetes 上运行的 HDFS 容器的可缩放群集。Deploy scalable clusters of SQL Server, Spark, and HDFS containers running on Kubernetes.

在 Transact-SQL 或 Spark 中读取、写入和处理大数据。Read, write, and process big data from Transact-SQL or Spark.

通过大容量大数据轻松合并和分析高价值关系数据。Easily combine and analyze high-value relational data with high-volume big data.

查询外部数据源。Query external data sources.

在由 SQL Server 管理的 HDFS 中存储大数据。Store big data in HDFS managed by SQL Server.

通过群集查询多个外部数据源的数据。Query data from multiple external data sources through the cluster.

将数据用于 AI、机器学习和其他分析任务。Use the data for AI, machine learning, and other analysis tasks.

大数据群集Big Data Clusters部署和运行应用程序Deploy and run applications in 大数据群集Big Data Clusters.

SQL Server 主实例使用 Always On 可用性组技术为所有数据库提供高可用性和灾难恢复。The SQL Server master instance provides high availability and disaster recovery for all databases by using Always On availability group technology.
通过 PolyBase 进行数据虚拟化Data virtualization with PolyBase 使用外部表从外部 SQL Server、Oracle、Teradata、MongoDB 和 ODBC 数据源查询数据,现在提供 UTF-8 编码支持Query data from external SQL Server, Oracle, Teradata, MongoDB, and ODBC data sources with external tables, now with UTF-8 encoding support. 有关详细信息,请参阅什么是 PolyBase?For more information, see What is PolyBase?.
   

有关详细信息,请参阅什么是 SQL Server 大数据群集Big Data ClustersFor more information, see What are SQL Server 大数据群集Big Data Clusters?.

智能数据库Intelligent Database

SQL Server 2019 (15.x)SQL Server 2019 (15.x) 在早期版本中的创新的基础上构建,旨在提供开箱即用的业界领先性能。builds on innovations in previous versions to provide industry-leading performance out of the box. 智能查询处理到对永久性内存设备的支持,SQL ServerSQL Server 智能数据库功能提高了所有数据库工作负荷的性能和可伸缩性,而无需更改应用程序或数据库设计。From Intelligent Query Processing to support for persistent memory devices, the SQL ServerSQL Server Intelligent Database features improve performance and scalability of all your database workloads without any changes to your application or database design.

智能查询处理Intelligent Query Processing

通过智能查询处理,可以发现关键的并行工作负荷在大规模运行时,其性能得到了改进。With Intelligent Query Processing, you know that critical parallel workloads improve when they're running at scale. 同时,它们仍可适应不断变化的数据世界。At the same time, they remain adaptive to the constantly changing world of data. 默认情况下,最新的数据库兼容性级别设置上支持智能查询处理,这会产生广泛影响,可通过最少的实现工作量改进现有工作负荷的性能。Intelligent Query Processing is available by default on the latest database compatibility level setting, delivering broad impact that improves the performance of existing workloads with minimal implementation effort.

新增功能或更新New feature or update 详细信息Details
行模式内存授予反馈Row mode memory grant feedback 通过调整批处理模式和行模式运算符的内存授予大小,扩展了批处理模式内存授予反馈功能。Expands on the batch mode memory grant feedback feature by adjusting memory grant sizes for both batch and row mode operators. 此调整可以自动纠正过度授予,过度授予会导致内存浪费和并发减少。This adjustment can automatically correct excessive grants, which result in wasted memory and reduced concurrency. 此调整还可纠正内存授予不足(会导致到磁盘的昂贵溢出)。It can also correct insufficient memory grants that cause expensive spills to disk. 请参阅行模式内存授予反馈See Row mode memory grant feedback.
行存储上的批处理模式Batch mode on rowstore 支持批处理模式执行,而无需使用列存储索引。Enables batch mode execution without requiring columnstore indexes. 批处理模式执行在分析工作负荷期间更高效地使用 CPU,但低于 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 的版本中,只有当查询包含具有列存储索引的运算时才使用它。Batch mode execution uses CPU more efficiently during analytical workloads but, until SQL Server 2019 (15.x)SQL Server 2019 (15.x), it was used only when a query included operations with columnstore indexes. 然而,有些应用程序可能会使用列存储索引不支持的功能,因此无法利用批处理模式。However, some applications might use features that aren't supported with columnstore indexes and, therefore, can't leverage batch mode. SQL Server 2019 (15.x)SQL Server 2019 (15.x) 起,批处理模式在符合条件的分析工作负载上启用,这些工作负载的查询包含具有任何类型索引(行存储或列存储)的运算。Starting with SQL Server 2019 (15.x)SQL Server 2019 (15.x), batch mode is enabled on eligible analytical workloads whose queries include operations with any type of index (rowstore or columnstore). 请参阅行存储上的批处理模式See Batch mode on rowstore.
标量 UDF 内联Scalar UDF Inlining 自动将标量 UDF 转换为关系表达式,并将它们嵌入调用 SQL 查询。Automatically transforms scalar UDFs into relational expressions and embeds them in the calling SQL query. 此转换提升了利用标量 UDF 的工作负载的性能。This transformation improves the performance of workloads that take advantage of scalar UDFs. 请参阅标量 UDF 内联See Scalar UDF Inlining.
表变量延迟编译Table variable deferred compilation 提升了引用表变量的查询的计划质量和整体性能。Improves plan quality and overall performance for queries that reference table variables. 在优化和初始编译期间,此功能传播基于实际表变量行计数的基数估计。During optimization and initial compilation, this feature propagates cardinality estimates that are based on actual table variable row counts. 这种准确的行计数信息可优化下游计划操作。This accurate row count information optimizes downstream plan operations. 请参阅表变量延迟编译See Table variable deferred compilation.
使用 APPROX_COUNT_DISTINCT 进行近似查询处理Approximate query processing with APPROX_COUNT_DISTINCT 对于绝对精度不重要、但响应速度很关键的情况,APPROX_COUNT_DISTINCT 使用比 COUNT(DISTINCT()) 更少的资源的同时跨大型数据集进行聚合,以实现高级并发。For scenarios when absolute precision isn't important but responsiveness is critical, APPROX_COUNT_DISTINCT aggregates across large datasets while using fewer resources than COUNT(DISTINCT()) for superior concurrency. 请参阅近似查询处理See Approximate query processing.
   

内存数据库In-Memory Database

SQL ServerSQL Server 内存数据库技术利用现代硬件创新提供无与伦比的性能和规模。In-Memory Database technologies leverage modern hardware innovation to deliver unparalleled performance and scale. SQL Server 2019 (15.x)SQL Server 2019 (15.x) 在此领域早期创新的基础上构建(例如内存中联机事务处理 (OLTP)),旨在为所有数据库工作负荷实现新的可伸缩性级别。builds on earlier innovations in this area, such as in-memory online transaction processing (OLTP), to unlock a new level of scalability across all your database workloads.

新增功能或更新New feature or update 详细信息Details
混合缓冲池Hybrid buffer pool SQL Server 数据库引擎SQL Server Database Engine的新功能,可以在需要时直接访问位于永久性内存 (PMEM) 设备上数据库文件中的数据库页。New feature of the SQL Server 数据库引擎SQL Server Database Engine where database pages sitting on database files placed on a persistent memory (PMEM) device will be directly accessed when required. 请参阅混合缓冲池See Hybrid buffer pool.
内存优化 TempDB 元数据Memory-optimized TempDB metadata SQL Server 2019 (15.x)SQL Server 2019 (15.x) 引入了一个新功能,该功能属于内存数据库功能系列内存优化 TempDB 元数据,它可有效消除此瓶颈,并为 TempDB 繁重的工作负荷解锁新级别的可伸缩性。introduces a new feature that is part of the In-Memory Database feature family, memory-optimized TempDB metadata, which effectively removes this bottleneck and unlocks a new level of scalability for TempDB heavy workloads. SQL Server 2019 (15.x)SQL Server 2019 (15.x) 中,管理临时表元数据时所涉及的系统表可以移动到无闩锁的非持久内存优化表中。In SQL Server 2019 (15.x)SQL Server 2019 (15.x), the system tables involved in managing temporary table metadata can be moved into latch-free non-durable memory-optimized tables. 请参阅内存优化 TempDB 元数据See Memory-Optimized TempDB Metadata.
内存中 OLTP 对数据库快照的支持In-Memory OLTP support for Database Snapshots SQL Server 2019 (15.x)SQL Server 2019 (15.x) 引入了对创建包含内存优化文件组的数据库的数据库快照的支持。introduces support for creating Database Snapshots of databases that include memory-optimized filegroups.
   

智能性能Intelligent performance

SQL Server 2019 (15.x)SQL Server 2019 (15.x) 在早期版本的智能数据库创新的基础上构建,旨在确保提高运行速度builds on Intelligent Database innovations in previous releases to ensure that it just runs faster. 这些改进有助于克服已知的资源瓶颈,并提供配置数据库服务器的选项,以在所有工作负荷中提供可预测性能。These improvements help overcome known resource bottlenecks and provide options for configuring your database server to provide predictable performance across all your workloads.

新增功能或更新New feature or update 详细信息Details
OPTIMIZE_FOR_SEQUENTIAL_KEY SQL Server 数据库引擎SQL Server Database Engine内启用优化,有助于提高索引中高并发插入的吞吐量。Turns on an optimization within the SQL Server 数据库引擎SQL Server Database Engine that helps improve throughput for high-concurrency inserts into the index. 此选项旨在用于易发生最后一页插入争用的索引,此情况常见于有顺序键(如标识列、序列或日期/时间列)的索引。This option is intended for indexes that are prone to last-page insert contention, which is typically seen with indexes that have a sequential key, such as an identity column, sequence, or date/time column. 请参阅创建索引See CREATE INDEX.
强制快进和静态游标Forcing fast forward and static cursors 提供对快速向前移动和静态游标的查询存储计划强制支持。Provides Query Store plan forcing support for fast forward and static cursors. 请参阅计划强制支持快进和静态游标See Plan forcing support for fast forward and static cursors.
资源调控Resource governance REQUEST_MAX_MEMORY_GRANT_PERCENTALTER WORKLOAD GROUPCREATE WORKLOAD GROUP 选项的可配置值已从整数更改为浮点数数据类型,以允许更精细地控制内存限制。The configurable value for the REQUEST_MAX_MEMORY_GRANT_PERCENT option of CREATE WORKLOAD GROUP and ALTER WORKLOAD GROUP has been changed from an integer to a float data type, to allow more granular control of memory limits. 请参阅修改工作负载组创建工作负载组See ALTER WORKLOAD GROUP and CREATE WORKLOAD GROUP.
减少了对工作负荷的重新编译Reduced recompilations for workloads 通过减少不必要的重新编译,改进了跨多个作用域使用临时表的性能。Improves performance when using temporary tables across multiple scopes by reducing unnecessary recompilations. 请参阅减少了对工作负荷的重新编译See Reduced recompilations for workloads.
间接检查点可伸缩性Indirect checkpoint scalability 请参阅改进了间接检查点可伸缩性See Improved indirect checkpoint scalability.
并发 PFS 更新Concurrent PFS updates 页可用空间 (PFS) 页是数据库文件中的特殊页面,SQL Server 用来在为对象分配空间时帮助定位可用空间。Page Free Space (PFS) pages are special pages within a database file that SQL Server uses to help locate free space when it allocates space for an object. PFS 页上的页闩锁争用通常与 TempDB 关联,但当有许多并发对象分配线程时,也可能会在用户数据库上发生。Page latch contention on PFS pages is commonly associated with TempDB, but it can also occur on user databases when there are many concurrent object allocation threads. 此改进改变了使用 PFS 更新来管理并发的方式,这样就能在共享闩锁(而不是排他闩锁)下更新它们。This improvement changes the way that concurrency is managed with PFS updates so that they can be updated under a shared latch, rather than an exclusive latch. SQL Server 2019 (15.x)SQL Server 2019 (15.x) 起,此行为在所有数据库(包括 TempDB)中默认处于启用状态。This behavior is on by default in all databases (including TempDB) starting with SQL Server 2019 (15.x)SQL Server 2019 (15.x).
计划程序辅助角色迁移Scheduler worker migration 通过辅助角色迁移,空闲的计划程序可将辅助角色从同一 NUMA 节点上其他计划程序的可运行队列中迁移,并立即恢复已迁移的辅助角色的任务。Worker migration allows an idle scheduler to migrate a worker from the runnable queue of another scheduler on the same NUMA node and immediately resume the task of the migrated worker. 在将长时间运行的任务恰好分配给同一计划程序的情况下,此增强功能可提供更均衡的 CPU 使用率。This enhancement provides more balanced CPU usage in situations where long-running tasks happen to be assigned to the same scheduler. 有关详细信息,请参阅 SQL Server 2019 智能性能 - 辅助角色迁移See SQL Server 2019 Intelligent Performance - Worker Migration for more information.
   

监视Monitoring

监视改善情况可供你在需要时随时对任何数据库工作负荷解锁性能见解。Monitoring improvements unlock performance insights over any database workload, just when you need them.

新增功能或更新New feature or update 详细信息Details
WAIT_ON_SYNC_STATISTICS_REFRESH sys.dm_os_wait_stats 动态管理视图中新的等待类型。A new wait type in sys.dm_os_wait_stats dynamic management view. 它显示了针对同步统计信息刷新操作耗费的实例级别累计时间。It shows the accumulated instance-level time spent on synchronous statistics refresh operations. 请参阅 sys.dm_os_wait_statsSee sys.dm_os_wait_stats.
查询存储的自定义捕获策略Custom capture policy for Query Store 启用此策略后,在新的“查询存储捕获策略”设置下有额外可用的查询存储配置,可用于微调特定服务器中的数据收集。When this policy is enabled, additional Query Store configurations are available under a new Query Store Capture Policy setting, to fine-tune data collection in a specific server. 请参阅 ALTER DATABASE SET 选项See ALTER DATABASE SET options.
LIGHTWEIGHT_QUERY_PROFILING 新数据库范围配置。A new database scoped configuration. 请参阅 LIGHTWEIGHT_QUERY_PROFILINGSee LIGHTWEIGHT_QUERY_PROFILING.
sys.dm_exec_requestscommandsys.dm_exec_requests column command 如果 SELECT 在继续执行查询之前等待同步统计信息更新操作完成,则显示 SELECT (STATMAN)Shows SELECT (STATMAN) if a SELECT is waiting for a synchronous statistics update operation to finish before it continues the query execution. 请参阅 sys.dm_exec_requestsSee sys.dm_exec_requests.
sys.dm_exec_query_plan_stats 新的动态管理函数 (DMF),可返回所有查询的最新已知实际执行计划的等效值。A new dynamic management function (DMF) that returns the equivalent of the last known actual execution plan for all queries. 请参阅 sys.dm_exec_query_plan_statsSee sys.dm_exec_query_plan_stats.
LAST_QUERY_PLAN_STATS 新的数据库范围的配置,可启用 sys.dm_exec_query_plan_statsA new database-scoped configuration that enables sys.dm_exec_query_plan_stats. 请参阅 ALTER DATABASE SCOPED CONFIGURATIONSee ALTER DATABASE SCOPED CONFIGURATION.
query_post_execution_plan_profile 扩展事件,基于轻型分析收集实际执行计划的等效项,与使用标准分析的 query_post_execution_showplan 不同。An extended event that collects the equivalent of an actual execution plan that's based on lightweight profiling, unlike query_post_execution_showplan, which uses standard profiling. 请参阅查询分析基础结构See Query profiling infrastructure.
sys.dm_db_page_info(database_id, file_id, page_id, mode) 新的 DMF,返回有关数据库中页面的信息。A new DMF that returns information about a page in a database. 请参阅 sys.dm_db_page_info (Transact-SQL)See sys.dm_db_page_info (Transact-SQL).
   

开发人员体验Developer experience

SQL Server 2019 (15.x)SQL Server 2019 (15.x) 继续提供一流的开发人员体验,并增强了图形和空间数据类型、UTF-8 支持以及新扩展性框架,该框架使开发人员可以使用他们选择的语言来获取其所有数据的见解。continues to provide a world-class developer experience with enhancements to graph and spatial data types, UTF-8 support, and a new extensibility framework that allows developers to use the language of their choice to gain insights across all their data.

图形Graph

新增功能或更新New feature or update 详细信息Details
边缘约束级联删除操作Edge constraint cascade delete actions 现可在图形数据库中,在边缘约束上定义级联删除操作。You can now define cascaded delete actions on an edge constraint in a graph database. 请参阅边缘约束See Edge constraints.
新增图形函数 - SHORTEST_PATHNew graph function - SHORTEST_PATH 现在可以使用 MATCH 内的 SHORTEST_PATH 来查找图中任意两个节点之间的最短路径,或执行任意长度遍历。You can now use SHORTEST_PATH inside MATCH to find the shortest path between any two nodes in a graph or to perform arbitrary length traversals.
分区表和索引Partition tables and indexes 图形表现在支持表和索引分区。Graph tables now support table and index partitioning.
在图形匹配查询中使用派生表或视图别名Use derived table or view aliases in graph match query 请参阅图形匹配查询See Graph match query.
   

Unicode 支持Unicode support

支持不同国家/地区和区域的业务,其中提供全球多语言数据库应用程序和服务的要求对于满足客户需求和符合特定市场规范至关重要。Support businesses across different countries and regions, where the requirement of providing global multilingual database applications and services is critical to meeting customer demands and complying with specific market regulations.

新增功能或更新New feature or update 详细信息Details
支持 UTF-8 字符编码Support for UTF-8 character encoding 支持使用 UTF-8 进行导入和导出编码,并用作字符串数据的数据库级别或列级别排序规则。Supports UTF-8 for import and export encoding, and as database-level or column-level collation for string data. 支持包括 PolyBase 外部表和 Always Encrypted(未用于 Enclave 时)。Support includes PolyBase external tables, and Always Encrypted (when not used with Enclaves). 请参阅排序规则和 Unicode 支持See Collation and Unicode Support.
   

语言扩展Language extensions

新增功能或更新New feature or update 详细信息Details
新 Java 语言 SDKNew Java language SDK 简化了可从 SQL Server 运行的 Java 程序的开发。Simplifies the development of Java programs that can be run from SQL Server. 请参阅 SQL Server 的用于 Java 的 Microsoft 扩展性 SDKSee Microsoft Extensibility SDK for Java for SQL Server.
Java 语言 SDK 是开放源代码的Java language SDK is open source Microsoft SQL Server 用于 Java 的 Microsoft 扩展性 SDK 目前是开源的,可在 GitHub 上获取The Microsoft Extensibility SDK for Java for Microsoft SQL Server is now open source and available on GitHub.
对 Java 数据类型的支持Support for Java data types 请参阅 Java 数据类型See Java data types.
新默认 Java 运行时New default Java Runtime SQL Server 现在包括 Azul System 的 Zulu Embedded,用于在整个产品中提供 Java 支持。SQL Server now includes Azul Systems Zulu Embedded for Java support throughout the product. 请参阅 Free supported Java in SQL Server 2019 is now available(SQL Server 2019 现已提供免费支持的 Java)。See Free supported Java in SQL Server 2019 is now available.
SQL Server 语言扩展SQL Server Language Extensions 使用扩展性框架执行外部代码。Execute external code with the extensibility framework. 请参阅 SQL Server 语言扩展See SQL Server Language Extensions.
注册外部语言Register external languages CREATE EXTERNAL LANGUAGE 是一种新的数据定义语言 (DDL),可在 SQL Server 中注册外部语言(如 Java)。A new Data Definition Language (DDL), CREATE EXTERNAL LANGUAGE, registers external languages, such as Java, in SQL Server. 请参阅 CREATE EXTERNAL LANGUAGESee CREATE EXTERNAL LANGUAGE.
   

空间Spatial

新增功能或更新New feature or update 详细信息Details
新的空间引用标识符 (SRID)New spatial reference identifiers (SRIDs) Australian GDA2020 提供了更为可靠和准确的数据,这些数据与全球定位系统提供的数据更加接近。Australian GDA2020 provides a more robust and accurate datum that's more closely aligned with global positioning systems. 新 SRID 为:The new SRIDs are:
  • 7843 表示地理 2D7843 for geographic 2D
  • 7844 表示地理 3D7844 for geographic 3D
有关新 SRID 的定义,请参阅 sys.spatial_reference_systems 视图。For definitions of new SRIDs, see sys.spatial_reference_systems view.
   

错误消息Error messages

当提取、转换和加载 (ETL) 进程由于源和目标没有匹配的数据类型和/或长度而失败时,故障排除会很耗时,尤其是在大型数据集中。When an extract, transform, and load (ETL) process fails because the source and the destination don't have matching data types and/or length, troubleshooting used to be time-consuming, especially in large datasets. 通过 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 可更快速地深入了解数据截断错误。SQL Server 2019 (15.x)SQL Server 2019 (15.x) allows faster insights into data truncation errors.

新增功能或更新New feature or update 详细信息Details
详细截断警告Verbose truncation warnings 数据截断错误消息默认包括表名和列名以及截断值。The data truncation error message defaults to include table and column names, and the truncated value. 请参阅 VERBOSE_TRUNCATION_WARNINGSSee VERBOSE_TRUNCATION_WARNINGS.
   

任务关键安全性Mission-critical security

SQL ServerSQL Server 提供安全的体系结构,旨在使数据库管理员和开发人员能够创建安全的数据库应用程序并应对威胁。provides a security architecture that's designed to allow database administrators and developers to create secure database applications and counter threats. 每个版本的 SQL ServerSQL Server 都在早期版本基础上进行了改进,并引入了新的特性和功能,SQL Server 2019 (15.x)SQL Server 2019 (15.x) 在此基础上继续进行构建。Each version of SQL ServerSQL Server has improved on previous versions with the introduction of new features and functionality, and SQL Server 2019 (15.x)SQL Server 2019 (15.x) continues to build on this story.

新增功能或更新New feature or update 详细信息Details
具有安全 Enclave 的 Always EncryptedAlways Encrypted with secure enclaves 通过对服务器端安全隔离区中的纯文本数据启用计算,使用就地加密和丰富计算扩展 Always Encrypted。Expands upon Always Encrypted with in-place encryption and rich computations by enabling computations on plaintext data inside a server-side secure enclave. 就地加密可提高加密列、旋转列、加密密钥等加密操作的性能和可靠性,因为这样可以避免将数据移出数据库。In-place encryption improves the performance and the reliability of cryptographic operations (encrypting columns, rotating columns, encryption keys, and so on), because it avoids moving data out of the database.

对丰富计算(模式匹配和比较操作)的支持可将 Always Encrypted 解锁到一组更广泛的方案和应用程序,这些方案和应用程序需要敏感数据保护,同时还需要在 Transact-SQL 查询中使用更丰富的功能。Support for rich computations (pattern matching and comparison operations) unlocks Always Encrypted to a much broader set of scenarios and applications that demand sensitive data protection, while also requiring richer functionality in Transact-SQL queries. 请参阅包含安全 Enclave 的 Always EncryptedSee Always Encrypted with Secure Enclaves.
SQL Server 配置管理器中的证书管理Certificate management in SQL Server Configuration Manager 现在可以使用 SQL Server 配置管理器来执行查看和部署证书等证书管理任务。Certificate management tasks such as viewing and deploying certificates is now possible by using SQL Server Configuration Manager. 请参阅证书管理(SQL Server 配置管理器)See Certificate Management (SQL Server Configuration Manager).
数据发现和分类Data Discovery & Classification 数据发现和分类功能提供对用户表中的列进行分类和标记的功能。Data Discovery & Classification provides capabilities for classifying and labeling columns in user tables. 对敏感数据(如商业、金融、医疗和 PII 等)进行分类,这在组织的信息保护中起到关键作用。Classifying sensitive data (business, financial, healthcare, PII, etc.) can play a pivotal role in an organizational information protection stature. 它可以充当基础结构,用于:It can serve as infrastructure for:
  • 帮助满足数据隐私标准和法规遵从性要求Helping meet data privacy standards and regulatory compliance requirements
  • 各种安全方案,如监视(审核),以及对敏感数据异常访问的警报Various security scenarios, such as monitoring (auditing) and alerting on anomalous access to sensitive data
  • 可以更轻松地识别企业中敏感数据所在的位置,以便管理员采取保护数据库的正确措施Making it easier to identify where sensitive data resides in the enterprise so admins can take the right steps securing the database
SQL Server 审核SQL Server Audit 另外,对审核进行了强化处理,在审核日志中包含了 data_sensitivity_information 新字段,其中包含查询返回的实际数据的敏感度分类(标签)。Auditing has also been enhanced to include a new field data_sensitivity_information in the audit log record, which contains the sensitivity classifications (labels) of the actual data that was returned by the query. 有关详细信息和示例,请参阅 ADD SENSITIVITY CLASSIFICATIONFor details and examples, see ADD SENSITIVITY CLASSIFICATION.
   

高可用性High availability

每位用户在部署 SQL ServerSQL Server 时都需执行一项常见任务,即确保所有任务关键型 SQL ServerSQL Server 实例以及其中的数据库在企业和最终用户需要时随时可用。One common task that everyone who deploys SQL ServerSQL Server has to account for is making sure that all mission critical SQL ServerSQL Server instances and the databases within them are available whenever the business and end users need them. 可用性是 SQL ServerSQL Server 平台的关键支柱,并且 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 引入了许多新功能和增强功能,使企业能够确保其数据库环境高度可用。Availability is a key pillar of the SQL ServerSQL Server platform, and SQL Server 2019 (15.x)SQL Server 2019 (15.x) introduces many new features and enhancements that allow businesses to ensure that their database environments are highly available.

可用性组Availability Groups

新增功能或更新New feature or update 详细信息Details
最多五个同步副本Up to five synchronous replicas SQL Server 2019 (15.x)SQL Server 2019 (15.x) 将同步副本的最大数目从 SQL Server 2017 (14.x)SQL Server 2017 (14.x) 中的 3 增加到了 5。increases the maximum number of synchronous replicas to 5, up from 3 in SQL Server 2017 (14.x)SQL Server 2017 (14.x). 可以配置此组的 5 个副本在该组中进行自动故障转移。You can configure this group of five replicas to have automatic failover within the group. 有 1 个主要副本以及 4 个同步的次要副本。There is one primary replica, plus four synchronous secondary replicas.
次要副本到主要副本连接重定向Secondary-to-primary replica connection redirection 允许客户端应用程序连接定向到主要副本,而不考虑在连接字符串中指定的目标服务器。Allows client application connections to be directed to the primary replica regardless of the target server specified in the connection string. 有关详细信息,请参阅次要副本到主要副本读/写连接重定向(AlwaysOn 可用性组)For details, see Secondary to primary replica read/write connection redirection (Always On Availability Groups).
HADR 权益HADR Benefits SQL Server 的每位软件保障客户都将能够对 Microsoft 仍支持的任何 SQL Server 版本使用三项增强权益。Every Software Assurance customer of SQL Server will be able to use three enhanced benefits for any SQL Server release that is still supported by Microsoft. 有关详细信息,请参阅此处的公告For details, see our announcement here.
   

恢复Recovery

新增功能或更新New feature or update 详细信息Details
加速数据库恢复Accelerated database recovery 通过加速数据库恢复 (ADR) 减少重启或长时间运行事务回滚后的恢复时间。Reduce the time to recover after a restart or a long-running transaction rollback with accelerated database recovery (ADR). 请参阅加速数据库恢复See Accelerated database recovery.
   

可恢复操作Resumable operations

新增功能或更新New feature or update 详细信息Details
联机聚集列存储索引生成和重新生成Online clustered columnstore index build and rebuild 请参阅联机执行索引操作See Perform Index Operations Online.
可恢复联机行存储索引生成Resumable online rowstore index build 请参阅联机执行索引操作See Perform Index Operations Online.
暂停和恢复透明数据加密 (TDE) 的初始扫描Suspend and resume initial scan for Transparent Data Encryption (TDE) 请参阅透明数据加密 (TDE) 扫描 - 暂停和继续See Transparent Data Encryption (TDE) scan - suspend and resume.
   

平台选择Platform choice

SQL Server 2019 (15.x)SQL Server 2019 (15.x) SQL Server 2017 (14.x)SQL Server 2017 (14.x) 中已引入的创新的基础上构建,旨在使你能够在所选平台上运行 SQL ServerSQL Server,并获得比以往更多的功能和更高的安全性。builds on the innovations that were introduced in SQL Server 2017 (14.x)SQL Server 2017 (14.x) to allow you to run SQL ServerSQL Server on your platform of choice with more functionality and security than ever before.

LinuxLinux

新增功能或更新New feature or update 详细信息Details
复制支持Replication support 请参阅 Linux 上的 SQL Server 复制See SQL Server Replication on Linux.
支持 Microsoft 分布式事务处理协调器 (MSDTC)Support for the Microsoft Distributed Transaction Coordinator (MSDTC) 请参阅如何在 Linux 上配置 MSDTCSee How to configure MSDTC on Linux.
OpenLDAP 支持第三方 AD 提供商OpenLDAP support for third-party AD providers 请参阅教程:对 Linux 上的 SQL Server 使用 Active Directory 身份验证See Tutorial: Use Active Directory authentication with SQL Server on Linux.
Linux 上的机器学习服务Machine Learning Services on Linux 请参阅在 Linux 上安装 SQL Server 机器学习服务(Python 和 R)See Install SQL Server Machine Learning Services (Python and R) on Linux.
TempDB 改进TempDB improvements 默认情况下,Linux 上的 SQL Server 新安装会根据逻辑核心数创建多个 TempDB 数据文件(最多 8 个数据文件)。By default, a new installation of SQL Server on Linux creates multiple TempDB data files, based on the number of logical cores (with up to eight data files). 这不适用于就地次要版本或主版本升级。This doesn't apply to in-place minor or major version upgrades. 每个 TempDB 文件的大小为 8 MB,且自动增长大小为 64 MB。Each TempDB file is 8 MB with an auto growth of 64 MB. 此行为类似于 Windows 上的默认 SQL Server 安装。This behavior is similar to the default SQL Server installation on Windows.
Linux 上的 PolyBasePolyBase on Linux 请参阅在 Linux 上为非 Hadoop 连接器安装 PolyBaseSee Install PolyBase on Linux for non-Hadoop connectors.

请参阅 PolyBase 类型映射See PolyBase type mapping.
变更数据捕获 (CDC) 支持Change Data Capture (CDC) support Linux 上的 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 现在支持变更数据捕获 (CDC)。Change Data Capture (CDC) is now supported on Linux for SQL Server 2019 (15.x)SQL Server 2019 (15.x).
   

容器Containers

开始使用 SQL ServerSQL Server 的最简单方法是使用容器。The easiest way to get started working with SQL ServerSQL Server is to use containers. SQL Server 2019 (15.x)SQL Server 2019 (15.x) 在早期版本中引入的创新的基础上构建,旨在使你能够以更安全的方式在新平台上部署 SQL ServerSQL Server 容器,并获得更多功能。builds on the innovations introduced in earlier versions to enable you to deploy SQL ServerSQL Server containers on new platforms, in a safer manner, and with more functionality.

新增功能或更新New feature or update 详细信息Details
Microsoft 容器注册表Microsoft Container Registry Microsoft 容器注册表现在将 Docker Hub 替换为新的官方 Microsoft 容器映像,其中包括 SQL Server 2019 (15.x)SQL Server 2019 (15.x)The Microsoft Container Registry now replaces Docker Hub for new official Microsoft container images, including SQL Server 2019 (15.x)SQL Server 2019 (15.x).
非根容器Non-root containers SQL Server 2019 (15.x)SQL Server 2019 (15.x) 引入了通过在默认情况下以非根用户身份启动 SQL ServerSQL Server 进程来创建更安全容器的功能。introduces the ability to create safer containers by starting the SQL ServerSQL Server process as a non-root user by default. 请参阅以非根用户的身份构建并运行 SQL Server 容器See build and run SQL Server containers as a non-root user.
Red Hat 认证的容器映像Red Hat certified container images SQL Server 2019 (15.x)SQL Server 2019 (15.x) 开始,可以在 Red Hat Enterprise Linux 上运行 SQL Server 容器。Starting with SQL Server 2019 (15.x)SQL Server 2019 (15.x), you can run SQL Server containers on Red Hat Enterprise Linux.
PolyBase 和机器学习支持PolyBase and Machine Learning support SQL Server 2019 (15.x)SQL Server 2019 (15.x) 引入了使用 SQL Server 容器的新方法,例如机器学习服务和 PolyBase。introduces new ways to work with SQL Server Containers such as Machine Learning Services and PolyBase. 查看容器 GitHub 存储库中的 SQL Server 中的一些示例。Check out some examples in the SQL Server in container GitHub repository.
   

安装选项Setup options

新增功能或更新New feature or update 详细信息Details
新内存设置选项New memory setup options 在安装过程中设置“最小服务器内存(MB)” 和“最大服务器内存(MB)” 服务器配置。Sets the min server memory (MB) and max server memory (MB) server configurations during installation. 请参阅“数据库引擎配置 - 内存”页,以及通过命令提示符安装 SQL Server 中的 USESQLRECOMMENDEDMEMORYLIMITSSQLMINMEMORYSQLMAXMEMORY 参数。See Database Engine Configuration - Memory page and the USESQLRECOMMENDEDMEMORYLIMITS, SQLMINMEMORY, and SQLMAXMEMORY parameters in Install SQL Server from the Command Prompt. 建议值遵循服务器内存配置选项中的内存配置准则。The proposed value aligns with the memory configuration guidelines in Server Memory Configuration Options.
新并行度设置选项New parallelism setup options 在安装过程中设置“最大并行度” 服务器配置。Sets the max degree of parallelism server configuration during installation. 有关详细信息,请参阅“数据库引擎配置 - MaxDOP”页,以及通过命令提示符安装 SQL Server 中的 SQLMAXDOP 参数。See Database Engine Configuration - MaxDOP page and the SQLMAXDOP parameter in Install SQL Server from the Command Prompt. 默认值遵循配置服务器配置选项“最大并行度”中的最大并行度准则。The default value aligns with the max degree of parallelism guidelines in Configure the max degree of parallelism Server Configuration Option.
服务器/CAL 许可证产品密钥的设置警告Setup warning on Server/CAL license Product Key 如果输入了企业服务器/CAL 许可证产品密钥,且计算机上有 20 多个物理内核,或者在启用超线程时有 40 个逻辑内核,则安装过程中会显示警告。If an Enterprise Server/CAL license Product Key is entered, and the machine has more than 20 physical cores, or 40 logical cores when Hyper-Threading is enabled, a warning is shown during setup. 用户仍然可以确认限制并继续设置,或者输入支持操作系统最大处理器数量的许可证密钥。Users can still acknowledge the limitation and continue setup, or enter a License Key that supports the operating system maximum number of processors.
   

SQL Server 机器学习服务SQL Server Machine Learning Services

新增功能或更新New feature or update 详细信息Details
基于分区的建模Partition-based modeling 可以使用添加到 sp_execute_external_script 的新参数来处理每个数据分区的外部脚本。You can process external scripts per partition of your data by using the new parameters added to sp_execute_external_script. 此功能支持训练多个小型模型(每个数据分区一个模型)而不是一个大型模型。This functionality supports training many small models (one model per partition of data) instead of one large model. 请参阅创建基于分区的模型See Create partition-based models.
Windows Server 故障转移群集Windows Server Failover Cluster 可在 Windows Server 故障转移群集上配置机器学习服务的高可用性。You can configure high availability for Machine Learning Services on a Windows Server Failover Cluster.
   

SQL Server Analysis ServicesSQL Server Analysis Services

此版本引入了新功能和针对性能、资源管理和客户端支持的改进。This release introduces new features and improvements for performance, resource governance, and client support.

新增功能或更新New feature or update 详细信息Details
表格模型中的计算组Calculation groups in tabular models 通过将常见度量值表达式分组为“计算项”,计算组可显著减少冗余度量值的数量 。Calculation groups can significantly reduce the number of redundant measures by grouping common measure expressions as calculation items. 要了解详细信息,请参阅表格模型中的计算组To learn more, see Calculation groups in tabular model.
查询交叉Query interleaving 查询交叉是一种表格模型系统配置,可在高并发情况下改善用户查询响应时间。Query interleaving is a tabular mode system configuration that can improve user query response times in high-concurrency scenarios. 要了解详细信息,请参阅查询交叉To learn more, see Query interleaving.
表格模型中的多对多关系Many-to-many relationships in tabular models 允许表之间存在多对多关系,两个表中的列都是非唯一的。Allows many-to-many relationships between tables where both columns are non-unique. 有关详细信息,请参阅表格模型中的关系To learn more, see Relationships in tabular models.
资源管理的属性设置Property settings for resource governance 此版本包含新的内存设置:针对资源管理的 Memory\QueryMemoryLimit、DbpropMsmdRequestMemoryLimit 和 OLAP\Query\RowsetSerializationLimit。This release includes new memory settings: Memory\QueryMemoryLimit, DbpropMsmdRequestMemoryLimit, and OLAP\Query\RowsetSerializationLimit for resource governance. 要了解详细信息,请参阅内存设置To learn more, see Memory settings.
Power BI 缓存刷新的调控设置Governance setting for Power BI cache refreshes 此版本引入了 ClientCacheRefreshPolicy 属性,该属性将替代缓存的仪表板磁贴数据以及 Power BI 服务初始加载 Live Connect 报表时的报表数据。This release introduces the ClientCacheRefreshPolicy property, which overrides caching dashboard tile data and report data for initial load of Live connect reports by the Power BI service. 有关详细信息,请参阅常规属性To learn more, see General Properties.
联机附加Online attach 联机附加可用于本地查询横向扩展环境中只读副本的同步。Online attach can be used for synchronization of read-only replicas in on-premises query scale-out environments. 要了解详细信息,请参阅联机附加To learn more, see Online attach.
   

SQL Server Integration ServicesSQL Server Integration Services

此版本引入了改进文件操作的新功能。This release introduces new features to improve file operations.

新增功能或更新New feature or update 详细信息Details
灵活的文件任务Flexible file task 在本地文件系统、Azure Blob 存储和 Azure Data Lake Storage Gen2 上执行文件操作。Perform file operations on Local File System, Azure Blob Storage, and Azure Data Lake Storage Gen2. 查看灵活的文件任务See Flexible File Task.
灵活的文件源和目标Flexible file source and destination 对 Azure Blob 存储和 Azure Data Lake Storage Gen2 读写数据。Read and write data for Azure Blob Storage, and Azure Data Lake Storage Gen2. 请参阅灵活的文件源灵活的文件目标See Flexible File Source and Flexible File Destination.

SQL Server Master Data ServicesMaster Data ServicesSQL Server Master Data ServicesMaster Data Services

新增功能或更新New feature or update 详细信息Details
支持 Azure SQL 托管实例数据库Support for Azure SQL Managed Instance databases 在 Azure SQL 托管实例上托管 Master Data ServicesMaster Data ServicesHost Master Data ServicesMaster Data Services on Azure SQL Managed Instance. 请参阅Master Data ServicesMaster Data Services安装和配置See Master Data ServicesMaster Data Services installation and configuration.
新 HTML 控件New HTML controls HTML 控件替换了所有以前的 Silverlight 组件。HTML controls replace all former Silverlight components. 已删除 Silverlight 依赖项。Silverlight dependency removed.
   

SQL Server Reporting ServicesSQL Server Reporting Services

此版本的 SQL Server Reporting Services 功能支持 Azure SQL 托管实例、Power BI Premium 数据集、增强的可访问性、Azure Active Directory 应用程序代理以及透明数据库加密。This release of SQL Server Reporting Services features support for Azure SQL Managed Instances, Power BI Premium datasets, enhanced accessibility, Azure Active Directory Application Proxy, and Transparent Database Encryption. 它还会更新 Microsoft 报表生成器。It also brings an update to Microsoft Report Builder. 有关详细信息,请参阅 SQL Server Reporting Services 中的新增功能See What's new in SQL Server Reporting Services for details.

另请参阅See also

后续步骤Next steps

获取帮助