Home > Articles > Data > SQL Server

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

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 allocated memory that is two times the on-disk size of the memory-optimized tables and indexes with a recommended maximum of 250GB. You also should have free disk space that’s two times the size of your durable memory-optimized tables.

  • + Share This
  • 🔖 Save To Your Account