60 minute session
Memory-Optimized tables - Querying at the speed of light
In this session we dive into the world of In-Memory OLTP and memory-optimized tables within SQL Server. Attendees gain insight into how this technology makes it possible to significantly accelerate database workloads by processing data directly in memory, with performance improvements that in practice can amount to a multiple of traditional solutions.
Besides the basic principles, we cover the underlying mechanics, such as data and delta files, transaction logging and concurrency models. We also cover, in practice, how to design and implement memory-optimized tables, including the use of hash indexes and the Memory Optimization Advisor.
Learning goals
- Understanding what In-Memory OLTP is and when to apply it
- Gaining insight into the architecture of memory-optimized tables
- Understanding how durability and transaction logging work within In-Memory OLTP
- Getting acquainted with snapshot-based isolation and optimistic concurrency
- Learning how to convert existing tables with the Memory Optimization Advisor
- Understanding how hash indexes work and how to design them effectively
- Understanding how to implement memory-optimized solutions
Level
Advanced
Topics
Materials