What is the PERSISTED_VERSION_CLEANER process?

Роман Губ'як 1 Reputation point
2020-09-16T06:28:18.523+00:00

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.
8,489 questions
{count} votes

2 answers

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,251 Reputation points Microsoft Employee
    2020-09-16T13:57:49.37+00:00

    @Роман Губ'як , 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.