SQL Server In-memory OLTP - Project Hekaton

Key Takeways #

Architectural Overview #

https://blogs.technet.microsoft.com/dataplatforminsider/2013/07/22/architectural-overview-of-sql-server-2014s-in-memory-oltp-technology/

Limitations #

https://msdn.microsoft.com/en-us/library/dn246937%28v=sql.120%29.aspx

Interesting Links #

In-memory OLTP Whitepaper:
https://www.microsoft.com/en-us/server-cloud/solutions/oltp-database-management.aspx

In-memory Team Blog:
https://blogs.technet.microsoft.com/dataplatforminsider/2013/06/26/sql-server-2014-in-memory-technologies-blog-series-introduction/

MSDN Docs
https://msdn.microsoft.com/en-us/library/dn133186.aspx

Choosing to Port
https://msdn.microsoft.com/en-us/library/dn205133.aspx

BrentOzar Comments:
https://www.brentozar.com/blitz/hekaton-memory-oltp-tables-use/

Jonathan Watts at RedGate:
https://www.simple-talk.com/sql/performance/the-promise—and-the-pitfalls—of-in-memory-oltp/

 
0
Kudos
 
0
Kudos

Now read this

Designing Infrastructure for SlackerNews Launch

Background # On Monday, I’m officially launching SlackerNews.io, the best of HackerNews, powered by artificial intelligence. In this post I describe the steps I took to ensure the burst of activity on Monday morning would be handled... Continue →