Why does enabling Snapshot Isolation use up CPU?

0 votes

0 answers

46 views

sql-server sql-server-2022 cpu snapshot-isolation

                          I'm currently enabling Snapshot Isolation with ALTER DATABASE [MyDB] SET ALLOW_SNAPSHOT_ISOLATION ON;. It was taking longer that I expected, so I ran sp_WhoIsActive. I was surprised to discover that it has used 81,519 units of CPU in 83 seconds. Why does this happen?
                        

Asked by J. Mini (1249 rep)

Aug 8, 2025, 09:14 PM

Why does enabling Snapshot Isolation use up CPU?

Related Questions