In SQL Server 2022, an additional option for DBCC SHRINKDATABASE and DBCC SHRINKFILE 'WAIT_AT_LOW_PRIORITY' changes the default behavior. In previous releases, shrinking databases and database files to reclaim space often leads to concurrency issues. See Accelerated database recovery for more details. This helps ensure that the ADR cleanup process doesn’t fail because user workloads can’t acquire table-level locks. User transaction cleanup – Another improvement is to allow user transactions to run cleanup on pages that couldn’t be cleaned up by the regular cleanup process due to lock conflicts.Reduced memory footprint for PVS page tracker – SQL Server 2022 implements a persistent version store (PVS) cleaner thread per database instead of per instance, and the memory footprint for PVS page tracker has been improved.To adjust the number of threads for version cleanup, you can configure the value through a parameter group. Multi-threaded version cleanup – An improvement was made to use multi-threaded version cleanup (MTVC), allowing multiple databases to be cleaned up in parallel.ADR improvement in SQL Server 2022 offers the following: This is achieved through versioning all physical database modifications and only undoing logical operations. It provides instantaneous transaction rollback irrespective of the time the transaction has been active or changes that have been performed. Accelerated database recovery improvementsĪccelerated database recovery (ADR) was introduced in SQL Server 2019 with the objective of improving database availability in the presence of long-running transactions by not impacting recovery time regardless of the number of active transactions or their sizes. The following are the SQL Server 2022 new and improved features now supported on Amazon RDS for SQL Server 2022. Amazon RDS for SQL Server 2022 supported features We also explain when and how the compatibility level of a database is set and review a few caveats with respect to some of the new features.

In this post, we summarize the new features on SQL Server 2022 that are supported in Amazon RDS for SQL Server. You can use SQL Server 2022 features such as accelerated database recovery, intelligent query processing, intelligent performance, monitoring improvements, and resumable online index creations.

Amazon Relational Database Service (Amazon RDS) for SQL Server now supports Microsoft SQL Server 2022 for Express, Web, Standard, and Enterprise Editions.

Free instals PVS-Studio 7.26.74066.377