Skip to content

deprecated-database-engine-features-in-sql-server-2022.md

Latest commit

 

History

History
55 lines (39 loc) · 2.9 KB

deprecated-database-engine-features-in-sql-server-2022.md

File metadata and controls

55 lines (39 loc) · 2.9 KB
title Deprecated Database Engine Features
titleSuffix SQL Server 2022
description Find out about deprecated Database Engine features that are still available in SQL Server 2022 (16.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 release-notes
ms.custom
ignite-2025
helpviewer_keywords
deprecated changes 2022 [SQL Server]
monikerRange >=sql-server-ver16 || >=sql-server-linux-ver16

Deprecated Database Engine features in SQL Server 2022 (16.x)

[!INCLUDE sqlserver2022]

[!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]. For information about deprecated features in other versions of [!INCLUDE ssnoversion-md], see:

Deprecation guidelines

When a feature is marked deprecated, it means:

  • The feature is in maintenance mode only. No new changes are made, including changes to address 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.

Query deprecated features

The values of these counters are also available by executing the following statement:

[!INCLUDE deprecated-os-performance-counters]

Related content