Monday 13 April 2015

@DBAreactions Guide to In-Memory OLTP (Hekaton)

Hekaton (also known as SQL Server In-Memory OLTP) is an in-memory database for OLTP workloads built into Microsoft SQL Server Hekaton was designed in collaboration with Microsoft Research and was released in SQL Server 2014.

Brent Ozar says:

At SQLbits last month, I presented a new session: Cool Story, Bro – The DBAreactions Guide to SQL Server 2014. I wanted to have some fun while educating folks about the surprise gotchas of the newest features.
Here’s the In-Memory OLTP (Hekaton) section of the session:



Their sp_Blitz® has long warned you if Hekaton is in use, and its Hekaton detail page shows some of the limitations.

No comments:

Post a Comment