Sample Header Ad - 728x90

Why not use Snapshot isolation for everything read-only?

5 votes
1 answer
424 views
Suppose that: - I already have Snapshot isolation enabled - I do not have Read Committed Snapshot Isolation enabled - I have been strict with my READCOMMITTEDLOCK hints wherever I truly need them then is there any reason at all to not use the Snapshot isolation level **for all read-only queries?** It seems that all of the costs from Snapshot isolation are paid at the moment that you enable the database-level setting rather than when you run queries under it.
Asked by J. Mini (1225 rep)
May 2, 2025, 10:54 PM
Last activity: May 3, 2025, 02:08 PM