Forum Discussion
yonisade
Oct 29, 2025Copper Contributor
"ALTER DATABASE CURRENT SET ALLOW_SNAPSHOT_ISOLATION ON" does not finish for several hours
I have tried enabling snapshot isolation on several SQL Server instances (2017 and 2022 developer editions) in single user mode with the same huge DB (4 TB) but the command does not finish even after 6 hours...
ALTER DATABASE CURRENT SET ALLOW_SNAPSHOT_ISOLATION ON
Session is waiting on "ENABLE_VERSIONING" and I don't see any noticeable I/O activity on the Windows disk itself.
No RepliesBe the first to reply