Created
February 5, 2019 07:49
-
-
Save ignas-sakalauskas/1d34ba25ab9a9c5c6c456744ee8fc508 to your computer and use it in GitHub Desktop.
MS SQL DB Isolation Levels
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DBCC useroptions | |
-- or | |
SELECT CASE | |
WHEN transaction_isolation_level = 1 | |
THEN 'READ UNCOMMITTED' | |
WHEN transaction_isolation_level = 2 | |
AND is_read_committed_snapshot_on = 1 | |
THEN 'READ COMMITTED SNAPSHOT' | |
WHEN transaction_isolation_level = 2 | |
AND is_read_committed_snapshot_on = 0 THEN 'READ COMMITTED' | |
WHEN transaction_isolation_level = 3 | |
THEN 'REPEATABLE READ' | |
WHEN transaction_isolation_level = 4 | |
THEN 'SERIALIZABLE' | |
WHEN transaction_isolation_level = 5 | |
THEN 'SNAPSHOT' | |
ELSE NULL | |
END AS TRANSACTION_ISOLATION_LEVEL | |
FROM sys.dm_exec_sessions AS s | |
CROSS JOIN sys.databases AS d | |
WHERE session_id = @@SPID | |
AND d.database_id = DB_ID(); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment