| title | Deprecated Database Engine Features | |
|---|---|---|
| titleSuffix | SQL Server 2025 | |
| description | Find out about deprecated Database Engine features that are still available in SQL Server 2025 (17.x), but shouldn't be used in new applications. | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| ms.reviewer | randolphwest | |
| ms.date | 11/18/2025 | |
| ms.service | sql | |
| ms.subservice | release-landing | |
| ms.topic | conceptual | |
| ms.custom |
|
|
| helpviewer_keywords |
|
|
| monikerRange | >=sql-server-ver15 || >=sql-server-linux-ver15 |
[!INCLUDE sqlserver2025]
[!INCLUDE sssql25-md] deprecates:
- The Hot add CPU feature.
- The lightweight pooling configuration option and the corresponding fiber mode feature.
Features that were deprecated in prior releases are also deprecated in [!INCLUDE sssql25-md]. For information about deprecated features in other versions of [!INCLUDE ssnoversion-md], see:
- Deprecated Database Engine features in SQL Server 2022 (16.x)
- Deprecated Database Engine features in SQL Server 2019 (15.x)
- Deprecated Database Engine features in SQL Server 2017 (14.x)
- Deprecated Database Engine features in SQL Server 2016 (13.x)
When a feature is marked deprecated, it means:
- The feature is in maintenance mode only. No new changes are added, including changes related to addressing interoperability with new features.
- We strive not to remove a deprecated feature from future releases to make upgrades easier. However, under rare situations, we might choose to permanently discontinue (remove) the feature from [!INCLUDE ssNoVersion] if it limits future innovations.
- For new development work, don't 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 [!INCLUDE ssNoVersion] 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]