Repeatable Read and Serializable Isolation Levels (45 minutes)

Serializable and Repeatable Read isolation levels offer protections so your users won’t see weird or incorrect data — but there are tradeoffs for those protections.

In this course, you’ll dig into:

  • How to tell if your existing applications are using these types of isolation levels
  • When you might want to raise your isolation level in SQL Server
  • The tradeoffs you make if you choose serializable or repeatable read with disk based tables.

Note: In this course, we focus on disk-based tables. In-Memory OLTP (“Hekaton”) works differently — it’s not lock-based! Learn about In-Memory OLTP and Isolation Levels here.

Course scripts

https://github.com/LitKnd/SQLWorkbooks/tree/main/repeatable_read_and_serializable_isolation_levels

Each video in this course has English captions available, as well as a transcript below the video.

Modules

Menu