This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I would like to know about this process:
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.
@Роман Губ'як , 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.
How to disable ADR temporarily? I cannot create index, change nullable column to nonnullable and perform other schema changes, because of it. I discovered in sp_who2 that my process is suspended most of the time, however that cleaner is always running.
ALTER DATABASE DB_Name SET ACCELERATED_DATABASE_RECOVERY = OFF
This does not work. See screenshot.
Hi @Роман Губ'як ,
ADR is new in SQL Server 2019. SQL Server 2014 RTM (12.0.2000.8) does not support ADR.
In addition, you can use the following query to check if ADR is enabled:
SELECT name
, is_accelerated_database_recovery_on
FROM SYS.DATABASES
WHERE name = 'dbname'
is_accelerated_database_recovery =1 means ADR is enabled.
Best Regards,
Amelia
Now I am confused. ADR isn't supported but it's turned on. It's turned on, but I cannot disable it because it's not supported. I didn't mention, that I use Azure SQL Database (just in case if it makes a difference).
Hi @Роман Губ'як ,
Sorry that I have no environment to test for you.
According to this article, ADR is enabled by default in Azure SQL Database and Azure SQL Managed Instance and disabling ADR for either product is not supported.
Best Regards,
Amelia
Ha! Article has been updated after I asked the question. https://github.com/MicrosoftDocs/azure-docs/commits/52d54f432e1a91d5e8c417c72f6daa0a77bb16a7/articles/azure-sql/accelerated-database-recovery.md
Nothing to say. It's just wasting of time.
Thank you everyone, who spent his time here for me!
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.
Best Regards,
Amelia