What is the PERSISTED_VERSION_CLEANER process?
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.
@Роман Губ'як Are you facing any specific issues?
Is this blocking any of your queries?
I will try and get more information on this internally from the product group.
Sign in to comment
Sort by: Oldest
@Роман Губ'як , 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.
Hi @Роман Губ'як ,
Did the answers help you?
If you find any post in the thread is helpful, you could kindly accept it as answer. This would benefit the community, and encourage the community member to keep working on your issues.