In-Memory OLTP: Internals and System Design Considerations

Synopsis:
In-Memory OLTP is one of the key SQL Server technologies, which can significantly improve performance of OLTP systems. In-Memory OLTP in SQL Server 2016 comes with many enhancements that reduce technology limitations and improve its usability. In many cases, you can even migrate the data into memory transparently to the code. Unfortunately, this simplicity may lead to suboptimal solutions due to the differences in technology behavior with the Classic Storage Engine.

This session provides the overview of In-Memory OLTP architecture and its internal implementation. It explains the key differences between the In-Memory OLTP and Storage Engines and gives the set of guidelines that may help during in-memory migration. Finally, the session demonstrates how to benefit from the technology in the systems with mixed (OLTP + DW) workloads when full in-memory migration is impossible or impractical. .

Bio:

Dmitri is a Microsoft SQL Server MVP and Microsoft Certified Master, author of "Pro SQL Server Internals" and "Expert SQL Server In-Memory OLTP" (http://amazon.com/author/dmitri-korotkevitch) with over 15 years of experience working with SQL Server as an Application and Database Developer, DBA, and Database Architect. Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.

https://secure.meetupstatic.com/photos/event/2/0/7/f/600_459728319.jpeg