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