Questions tagged [snapshot-isolation]
53 questions
0
votes
1 answer
Snapshot isolation transaction aborted due to update conflict for selected rows
Snapshot isolation transaction aborted due to update conflict. You
cannot use snapshot isolation to access table directly or indirectly
in database to update, delete, or insert the row that has been
modified or deleted by another transaction.…
girish kolte
- 93
- 2
- 9
0
votes
0 answers
Comparison of SQL Server database settings with isolation levels
Over the last few years, we have noticed an increase in the number of deadlocks and long-running transactions in our SQL server (2008r2) database. We currently run our database with the following settings ALLOW_SNAPSHOT_ISOLATION OFF and…
Steve
- 1
- 2
0
votes
0 answers
Introducing TransactionScope into existing Project
I would like to run one particular Linq2Sql query in snapshot isolation mode without affecting the rest of my application.
However whenever I use code like
using (var t = new TransactionScope(TransactionScopeOption.Required,
new…
sgmoore
- 15,694
- 5
- 43
- 67
0
votes
0 answers
Make transaction fail with conflict if a row previously read is changed by a concurrent transaction
If a row is modified by a transaction that uses the SNAPSHOT isolation level, any concurrent update (by another transaction) to the same row causes the SNAPSHOT transaction to fail with a conflict.
Is there a way to have the same behavior happen…
Flavien
- 7,497
- 10
- 45
- 52
0
votes
1 answer
Configure IIS web config for my webapi app to use snapshop isolation
Due to performance in our system (deadlocks, db reads are locked when db writes are in progress, etc) we want to try out snapshop isolation. I have read about snapshot isolation level, here. We use Entity Framework
I have set Snapshop isolation on…
JohanLarsson
- 475
- 1
- 8
- 23
0
votes
3 answers
Read Committed Snapshot Isolation: Does Update Conflict Rollback appear as Deadlock?
I have read committed snapshot isolation and allow isolation ON for my database. I'm still receiving a deadlock error. I'm pretty sure I know what is happening...
First transaction gets a sequence number at the beginning of its transaction.
Second…
Eric J. Price
- 2,740
- 1
- 15
- 21
-2
votes
1 answer
ASP.Net MVC 5 and SQL Transaction Isolation Levels
Having an issue with the creation of a front end for a database. I began with a EF6 Code First from database. I created the controller and went to run a test on the create page, but ran into a big issue. It gave me the following error:
…
Mike Mastro
- 121
- 3
- 16
-2
votes
1 answer
Can you still lock rows exclusively (block readers) in a SQL Server db that has Snapshot Isolation and RCSI enabled?
Can you still lock rows exclusively (block readers) in a SQL Server db that has Snapshot Isolation and RCSI enabled?
I want to basically do a xlock, rowlock select on a table.
BigErn77
- 47
- 3