First look at the In-Memory OLTP database engine component in SQL Server 2014

You may have heard about the new in-memory OLTP database engine component (formerly known as Hekaton) in SQL Server 2014, but would like to see it in action. I gave this demo-packed talk at Microsoft Campus Days 2013 in Copenhagen, where we took a first look at the in-memory OLTP capability, where mission critical data can be accessed and processed more effectively by declaring tables as memory-optimized. In this session, we looked at not only how In-Memory OLTP memory-optimized tables are stored and how SQL Server is working with the data, but also how natively compiled procedures can be used to improve performance further. Also we looked at the limitations of using In-Memory OLTP.

This talk was first given at Microsoft Campus Days 2013 on 9 October 2013.

Demo scripts can be downloaded here. Video is available on Channel 9.

Update: an updated slide deck for SQL Server 2014 CTP2 can be found here.

Leave a Reply