Remember “Nothing Stops a Hekaton Transaction?” Yeah, About That.


When In-Memory OLTP first came out, Microsoft liked to go around bragging at conferences that “Nothing stops a Hekaton transaction.” I remember hearing that and kinda chuckling at the time, and I was reminded of it by a recent client who was running into blocking issues with…yep, Hekaton.

To reproduce it:

Do a large insert into an in-memory OLTP table In another window, try to truncate that table (which gets blocked by query #1) In another window, try to another insert into that table (which gets blocked by query #2)

The results of sp_WhoIsActive show blocking:

The reason is