Роман Губ'як 6 Reputation points

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.
12,313 questions
{count} votes

2 answers

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,316 Reputation points

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