Search code examples
sql-serveroltpin-memory-tables

How Many RAM is available in MS SQL Server Express Edition using the In-Memory OLTP technique

Starting with the 2016 version the In-Memory-technique is also integrated in the MS SQL Server Express edition. In fact as the Express version is limited to 1 GB RAM I'm wondering whether the RAM for the In-Memory OLTP technique is used as part of the 1 GB RAM or whether it will not affect the 1 GB RAM.

Solution

  • The buffer pool and memory for In-Memory OLTP objects are separate limits, documented here:

    Editions and supported features of SQL Server