Deadlocked!: “read committed snapshot” Explained

home
database
view story

2 Kicks

Deadlocked!: “read committed snapshot” Explained(coderjournal.com)

submitted by zigamorph(3319) 3 years, 9 months ago

I just recently read Jeff Atwood’s Deadlocked! article. I just wanted to give some more insight in to the read committed snapshot so that it is not perceived as “magic”. It has some definite advantages when dealing with deadlocks, however if your code relies on row level locking you are not going to be able to use this type of reading in SQL Server. First lets talk about how you enable it. It is not a transactional isolation level, so if you set it, it will effect your whole database. You have been warned!

add a comment |category: Database |Views: 65
Tweet