Stack Overflow
Stack Overflow

Questions tagged [snapshot-isolation]

53 questions
2
votes
1 answer

Snapshot isolation transaction aborted due to update conflict in SQL Server due to FK checks - Part 2

This work follows on from Snapshot isolation transaction aborted due to update conflict in SQL Server due to FK checks. After looking at this excellent article…
Sputnik
  • 39
  • 4
2
votes
1 answer

Postgres SSI Behavior

I'm trying to get an understanding of how SSI is actually supposed to behave in Postgres. My understanding is, if I have two transactions interacting with the same table, but the transactions aren't interacting with the same rows in the table, then…
Jackson Kelley
  • 412
  • 5
  • 13
2
votes
3 answers

Do I get any performance gain by using WITH (NOLOCK) on SQL Server database where READ_COMMITTED_SNAPSHOT is switched on?

I have a database on Microsoft SQL Server 2014 where READ_COMMITTED_SNAPSHOT property is switched on. I understand that this means that reads are not blocked by writes because reads do not issue shared locks and that this is clean reading. My…
Jiri Necas
  • 33
  • 6
2
votes
2 answers

Why is snapshot isolation level off by default?

In MS SQL Server, in order to run a transaction with SNAPSHOT isolation level, it first needs to be turned on at the database level. I can only assume that turning this flag ON comes with some downsides the DBA needs to be aware of. But I don't know…
Cristian Diaconescu
  • 34,633
  • 32
  • 143
  • 233
2
votes
1 answer

What is the SELECT @@IDENTITY will return if I have Transactional Query with IsolationLevel.Snapshot in multiple and simultaneous query?

I have a table access by multiple applications with multiple transactions and I want these multiple applications/transactions to get each Primary Key / Identity inserted accordingly by application who execute that transaction. For some reason I…
jtabuloc
  • 2,479
  • 2
  • 17
  • 33
2
votes
2 answers

SQL Server Bookmark Lookup Deadlock solution

I detected a bookmark lookup deadlock in my application, and I can't decide which solution to use. None of them seem to be optimal. Here are the queries: UPDATE TEST SET DATA = @data WHERE CATEGORY = @cat SELECT DATA, EXTRA_COLUMN FROM TEST WHERE…
dinhokz
  • 895
  • 15
  • 36
2
votes
1 answer

How to bulk update a SQL server database with a lot of active readers

I am designing a solution for a SQL Server 2012 database for the following scenario The database contains about 1M records with some simple parent child relationships between 4 or 5 tables There is a 24x7 high load of reads on the database Once a…
Frank Bakker
  • 471
  • 4
  • 14
2
votes
1 answer

SQL Server 2005 becomes blocked with no locked or locking processes

We have a database (let's call it database A) which becomes unusable every some days and we have to restart it. When I say unusable means all applications using it just block there waiting for the database to respond but it never does. By luck it…
Timmo
  • 3,142
  • 4
  • 26
  • 43
2
votes
0 answers

Snapshot Isolation MVCC & B+ trees

I'm developing on a NoSQL database that uses 64-bit hash-based B+ trees for some of its indexes, now I'm looking into applying Snapshot Isolation Multiversion concurrency control (SI MVCC) on the persistent B+ tree. The first issue I'm confronted…
user152949
1
vote
2 answers

Implementing ranged queries with B+trees and snapshot isolation

I'm developing a new NoSQL database server product. Are there any papers on how to implement range queries on clustered B+ trees that uses snapshot isolation?
user152949
1
vote
1 answer

Unable to create a SnapShot in IOS

Any ideas why this would be happening? Corrupt directory perhaps? I did a lot of copying back and forth with these files.
John Stack
  • 618
  • 1
  • 4
  • 19
1
vote
2 answers

SQL Server - inconsistent behavior when reading uncommitted changes of the same transaction

Working with SQL server with isolation level "read committed snapshot", we routinely write data to the database and read it further on in the context of the same transaction. Usually when reading from the database we see our own uncommitted changes…
Youval Bronicki
  • 1,922
  • 2
  • 18
  • 18
1
vote
0 answers

Snapshot isolation transaction failed in database 'tempdb' because the object accessed by the statem

I have set allow_snapshot_isolation and READ_COMMITTED_SNAPSHOT on my application database. I have SP's which use temp tables. In case of concurrent access on of the SP throws below error. None of the SP have alter temp table command , i mean it is…
Sagar
  • 645
  • 2
  • 9
  • 31
1
vote
1 answer

Ignore Dacpac Snapshot options during publish

Is it possible to ignore the snapshot options set in a given database project's project settings, when deploying its dacpac (either through sqlpackage.exe, DacFx or Visual Studio)?
Simon Green
  • 1,131
  • 1
  • 10
  • 28
1
vote
0 answers

SQL Server 2008 R2 Snapshot isolation issue

I'm using SET TRANSACTION ISOLATION LEVEL SNAPSHOT with snapshot enabled on the database but what I'm noticing is that if I do a simple delete statement such as BEGIN TRANSACTION DELETE * FROM TableA INSERT INTO TableA(...) SELECT (...) FROM…
Silent Fart
  • 111
  • 2
  • 13
1
2
3 4