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