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

Upgrading EntityFramework

Does ApplyCurrentValues() ring a bell for you? If so you’re probably as excited as I am with the latest version of EntityFramework and the simplified APIs for interacting and manipulating object state. At Wheelhouse almost all of our... Continue →