Persistence is Futile - Implementing Delayed Durability in SQL Server

The concurrency model of most Relational Database Systems are defined by the ACID properties but as they aim for ever-increasing transactional throughput, those rules are bent, ignored, or even broken. In this session, we will investigate how SQL Server implements transactional durability in order to understand how Delayed Durability bends the rules to remove transactional bottlenecks and achieve improved throughput. We will take a look at how this can be used to compliment In-Memory OLTP performance, and how it might impact or compromise other things. Attend this session and you will be assimilated!
Presented by Mark Broadbent at SQLBits 2018
MP4 Video Low 420 MB
MP4 Video Med 765 MB
MP4 Video High 1,187 MB
MP4 Video HD 2,244 MB