Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

In-Memory OLTP Internals - Understanding the 30x Performance Boost in SQL Server Hekaton

PASS Data Community Summit via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Explore SQL Server Hekaton (In-Memory OLTP) architecture and performance optimization in this technical session presented by 20-year SQL Server MVP Kalen Delaney. Learn how this revolutionary technology transforms data management by keeping all data in memory while using disk storage primarily as a REDO log. Discover the architectural differences in memory and storage requirements, understand the internal workings of memory-optimized tables and indexes, and examine checkpoint operations and disk writing processes. Gain deep insights into the mechanisms behind Hekaton's remarkable 30x performance boost and understand how this technology can revolutionize database administration practices.

Syllabus

24 Hours of PASS: Summit Preview - In Memory OLTP Internals: How is a 30x Performance Boost Possible

Taught by

PASS Data Community Summit

Reviews

Start your review of In-Memory OLTP Internals - Understanding the 30x Performance Boost in SQL Server Hekaton

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.