| title | Deprecated database engine features in SQL Server 2022 | |
|---|---|---|
| titleSuffix | SQL Server 2022 | |
| description | Deprecated database engine features in [!INCLUDE[sssql22-md](../includes/sssql22-md.md)] | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| ms.reviewer | randolphwest | |
| ms.date | 07/25/2022 | |
| ms.service | sql | |
| ms.subservice | release-landing | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| monikerRange | >=sql-server-ver16||>=sql-server-linux-ver16 |
[!INCLUDEsqlserver2022]
[!INCLUDE sssql22-md] deprecates:
- Distributed Replay
- Machine Learning server
- Stretch Database
Features that were deprecated in prior releases are also deprecated in [!INCLUDE sssql22-md]:
- Deprecated database engine features in SQL Server 2019 (15.x)
- [[!INCLUDE sssql17-md]](deprecated-database-engine-features-in-sql-server-2017.md)
- [[!INCLUDE sssql16-md]](deprecated-database-engine-features-in-sql-server-2016.md)
When a feature is marked deprecated, it means:
- The feature is in maintenance mode only. No new changes will be done, including those related to addressing inter-operability with new features.
- We strive not to remove a deprecated feature from future releases to make upgrades easier. However, under rare situations, we may choose to permanently discontinue (remove) the feature from [!INCLUDEssNoVersion] if it limits future innovations.
- For new development work, do not use deprecated features. For existing applications, plan to modify applications that currently use these features as soon as possible.
You can monitor the use of deprecated features by using the [!INCLUDEssNoVersion] Deprecated Features Object performance counter, or the deprecation_announcement and deprecation_final_support extended events. For more information, see Use SQL Server Objects.
The values of these counters are also available by executing the following statement:
[!INCLUDE deprecated-os-performance-counters]