Book Image

Getting Started with SQL Server 2014 Administration

By : Gethyn Ellis
Book Image

Getting Started with SQL Server 2014 Administration

By: Gethyn Ellis

Overview of this book

Table of Contents (13 chapters)
Getting Started with SQL Server 2014 Administration
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Requirements


There are a number of requirements you need to satisfy in order to utilize In-Memory Optimized tables. These are as follows:

  • In-Memory Optimized tables require the Enterprise edition SQL Server 2014 (the Developer and Evaluation editions also have all the features of the Enterprise edition but cannot be used in production environments)

  • The SQL Server will need enough memory (RAM) to hold the data stored in the In-Memory Optimized tables

  • If you are using disk-based tables, then you will also need enough RAM for the buffer pool

  • You will need a processor that supports the CMPXCHG16B instruction set—all modern 64-bit processors support the CMPXCHG16B instruction set