Introduction

The cleaner is an asynchronous process that wakes up periodically and cleans page versions that aren’t needed. By default, this configuration setting is set to 1. This means that the cleaner uses a single thread to clean persistent version store (PVS) in all databases on the database engine instance.

Problem

Change the number of threads on Accelerated Database Recovery (”ADR”)

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_change_server_adr_cleaner.sql