Design principles of the in-memory OLTP engine – Avoid CPU and memory overhead for interpreted T-SQL

In this blog, I explain why the in-memory OLTP engine is significantly faster than the traditional on-disk engine. T-SQL is interpreted code with high CPU and memory overhead when SQL Server has to compile the command before it can be executed by the engine. In-memory OLTP reduces the number of recompilations, which may lead to much faster query execution with less impact on CPU and memory.