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

2013/10/11 — Leave a comment

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.

David Peter Hansen

Posts Twitter

David Peter Hansen is a Microsoft Certified Master of SQL Server and works as Senior Manager at Hitachi Consulting in London. He has worked with database development and administration for 12 years, and has worked with the Microsoft Business Intelligence platform since SQL Server 2000. He specializes in developer coaching as well as scalable architecture and performance tuning on large-scale data warehouses and BI solutions. He is a frequent speaker at SQL Server and BI conferences.

No Comments

Be the first to start the conversation.

Leave a Reply