| description | Deprecated database engine features in [!INCLUDE[sssql19-md](../includes/sssql19-md.md)] | |
|---|---|---|
| title | Deprecated database engine features in SQL Server 2019 | Microsoft Docs | |
| titleSuffix | SQL Server 2019 | |
| ms.custom | seo-lt-2019 | |
| ms.date | 02/12/2021 | |
| ms.prod | sql | |
| ms.prod_service | high-availability | |
| ms.reviewer | ||
| ms.technology | release-landing | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | ||
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| monikerRange | >=sql-server-ver15||>=sql-server-linux-ver15 |
[!INCLUDEsqlserver2019]
[!INCLUDE sssql19-md] does not deprecate any features beyond those deprecated in prior releases:
- [[!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 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 remove the feature from [!INCLUDEssNoVersion] if it limits future innovations.
- For new development work, we do not recommend using deprecated features.
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:
SELECT * FROM sys.dm_os_performance_counters
WHERE object_name = 'SQLServer:Deprecated Features';