Skip to main content This browser is no longer supported. Show Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. What's new in SQL Server 2022 (16.x)
In this articleApplies to: SQL Server 2022 (16.x) SQL Server 2022 (16.x) 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. The following video introduces SQL Server 2022 (16.x). For additional video content, see:
This article summarizes the new features and enhancements for SQL Server 2022 (16.x). Get SQL Server 2022 (16.x)Get SQL Server 2022 Evaluation Edition. Build number: 16.0.1000.6. For more information and known issues, see SQL Server 2022 (16.x) release notes. For the best experience with SQL Server 2022 (16.x), use the latest tools. Feature highlightsThe following sections identify features that are improved our introduced in SQL Server 2022 (16.x).
Analytics
Availability
Security
Performance
Query Store and intelligent query processingThe intelligent query processing (IQP) feature family includes features that improve the performance of existing workloads with minimal implementation effort.
Management
Platform
Language
SQL Machine Learning ServicesBeginning with SQL Server 2022 (16.x), runtimes for R, Python, and Java, are no longer installed with SQL Setup. Instead, install any desired custom runtime(s) and packages. For more information, see Install SQL Server Machine Learning Services (Python and R) on Windows or Install SQL Server Machine Learning Services (Python and R) on Linux. Additional informationThis section provides additional information for the features highlighted above. Query Store improvementsQuery Store helps you better track performance history, troubleshoot query plan related issues, and enable new capabilities in Azure SQL Database, Azure SQL Managed Instance, and SQL Server 2022 (16.x). CTP 2.1 introduces Query Store enabled by default for new databases. If you need to enable the query store, see Enable the Query Store.
If there's concern about the
overhead Query Store may introduce, administrators can use custom capture policies to further tune what the Query Store captures. Custom capture policies are available to help further tune Query Store captures. Custom capture policies can be used to be more selective about which queries, and query details are captured. For example, an administrator may choose to capture only the most expensive queries, repeated queries, or the queries that have a high level of compute overhead.
Custom capture policies can help Query Store capture the most important queries in your workload. Except for the STALE_CAPTURE_POLICY_THRESHOLD option, these options define the OR conditions that need to happen for queries to be captured in the defined Stale Capture Policy Threshold
value. For example, these are the default values in the
SQL Server Analysis ServicesThis release introduces new features and improvements for performance, resource governance, and client support. For specific updates, see What's new in SQL Server Analysis Services. SQL Server Reporting ServicesThis release introduces new features and improvements for accessibility, security, reliability, and bug fixes. For specific updates, see What's new in SQL Server Reporting Services (SSRS). See also
Get help
FeedbackSubmit and view feedback for |