In-Memory Optimization Requirements
The In-Memory OLTP engine is supported only in the 64 bit Enterprise, Developer, or Evaluation editions of SQL Server 2014 running in a 64 bit version Windows Server 2012 R2, Windows Server 2012, or Windows Server 2008 R2 SP2. The In-Memory OLTP engine also requires an x64 server that supports the cmpxchg16b instruction, which all modern x64 processors do. You may run into a problem if you are implementing the In-Memory OLTP engine in a 64-bit virtual machine (VM) that’s using an older virtual processor.
SQL Server will also require enough memory to store the tables and indexes of the tables you designate to be memory-optimized, plus additional memory for the row versions. The general recommendation is to ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
