Isolation Levels

Question

For reading dirty data you can set isolation levels at a Connection level using

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

Do any of these help with locking / blocking issues at a global level?

ALTER DATABASE MyDatabase
SET ALLOW_SNAPSHOT_ISOLATION ON

or

ALTER DATABASE MyDatabase
SET READ_COMMITTED_SNAPSHOT ON

Answer 1

0

I added tags for transaction and isolation-level to your question. There are some good answers in some of the previous questions:

short answer: Yes, both help by reducing the need for locking but both also increase usage of tempdb.

answered Nov 18 '09 at 02:39 PM

Tom Staab
5.8k ● 5 ● 8 ● 10

Just to clarify, those options are not for dirty reads. They are used to avoid lock/block issues when dirty reads are unacceptable.

Nov 18 '09 at 02:40 PM Tom Staab

Good answer as usual, sir.

Nov 18 '09 at 04:27 PM Matt Whitfield ♦♦

(comments are locked)