Inside SQL Server In-Memory OLTP
Duration: 60 minutes
Track: Enterprise Database Administration & Deployment
Based on the successful 500 Level talk at PASS 2016, this session will provide an internals view of how In-Memory OLTP works for SQL Server 2016. Because this session is Advanced, it is intended for those that understand the basic fundamentals of In-Memory OLTP but want to learn how the "Hekaton" engine works behind the scenes to deliver the amazing 30x performance improvements seen for customers moving to In-Memory OLTP. This session will include a look behind the scenes at threads, data and index design, transactions and concurrency, logging, storage, and natively compiled procedures. And since this will be an advanced level session, of course the demonstration of the looking at the Hekaton engine with the debugger is a must.