I have a lot of deadlocks going on in my system.
I would like to use Snapshot Isolation to fix them, but my DBA has reserves about it.
One of his concerns is that Snapshot Isolation slows down writes. This is because it has to write to cache and then to the TempDb (row version) and then it can return to the caller.
A "normal" write can just write to the cache and then be done.
Is this how the row versioning works? Or is it more complex than that? Does it somehow do these in parallel?
Or are writes slower with Snapshot Isolation?