Tagged Questions
3
votes
1answer
273 views
How to force the use of row locks?
I am trying to get my table to use row locks. I have already disabled lock escalation. The isolation level is READ_COMMITTED_SNAPSHOT
alter table <TABLE_NAME> SET (LOCK_ESCALATION=DISABLE)
go
...
8
votes
1answer
254 views
Are SQL Server Database writes slower with Snapshot Isolation?
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 ...
3
votes
3answers
207 views
Does Snapshot Isolation only give you what has been commited? (And General Snapshot Isolation questions.)
So, I have some deadlocking issues.
I have seen two options to resolve it. Add read uncommitted to my db or do Snapshot Isolation and add read committed snapshot.
After doing some research into ...
