Роман Губ'як 1 Reputation point

I would like to know about this process:

  • What is its purpose?
  • When is it running?
  • What does it perform?
  • Why does it use a lot of CPU&DATAIO?

I cannot find any documentation about PERSISTED_VERSION_CLEANER.

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
{count} votes

2 answers

Sort by: Newest
  1. KalyanChanumolu-MSFT 8,251 Reputation points Microsoft Employee

    @Роман Губ'як , I have checked this internally and as @Tom Phillips pointed out, this is part of the implementation of accelerated database recovery. It uses page versioning to reduce recovery time on failovers. This is turned on by default on Azure SQL Database

    If you are seeing abnormally high waits on this, please reach out to Azure Support.

    2 people found this answer helpful.