0

I have ADR enabled on my production database running on SQL Server 2019. In the SQL Server logs , it shows the messages:

[VersionCleaner][DbId:6][sweepOfSelectivePages]: Cleanup of sidelist aborted due to timeout 0 minutes. 130686 number of pages have been processed

I did not get information about these messages in any blogs. can you help me understand the messages?

1

1 Answer 1

0

This is more of a comment than an answer but I'd start by trying to understand what might be causing the cleanup of the persistent version store and possibly try running the PVS cleanup manually.

There's lots of advice here - https://learn.microsoft.com/en-us/sql/relational-databases/accelerated-database-recovery-troubleshoot?view=sql-server-ver15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.