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.

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s