DPA上Deadlock上の表記について

Question

お世話になります。

Deadlockが発生しており、対応しているのですが

DPA上のDeadlock Details内に下記項目と値が表示されています。

この(2)というのはどういう意味なのでしょうか。

Isolation Level:read committed (2)

mandevil · Answer

Same isolation level. Good article here explaining it:

https://blog.sqlauthority.com/2015/07/03/sql-server-difference-between-read-committed-snapshot-and-snapshot-isolation-le…

zozoused · Answer

Thanks!!

But dbcc userotion result is "read committed snapshot"

mandevil · Answer

That is coming from MS SQL Server itself and determines what kinds of reads or operations are allowed given the isolation level set.

The two is just the numeric identifying a "Read Committed" isolation level.

For a complete writeup about isolation levels, check this out: Understanding Isolation Levels | Microsoft Docs