Repeatable Read and Serializable Isolation Levels (45 minutes)

Repeatable Read and Serializable Isolation Levels (45 minutes)

December 15, 2017

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.