A question from my class:

How to find SQL Server current isolation level of the session?

Thanks to DMVs.

SQL Server Current isolation level

where:

1 = READ UNCOMMITTED

2 = READ COMMITTED

3 = REPEATABLE READ

4 = SERIALIZABLE

5 = SNAPSHOT

 

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter