In-Memory Optimized Tables | Getting Started with SQL Server 2014 Administration

Memory-optimized tables

The following quote is from the SQL Server 2014 documentation:

"SQL Server In-Memory OLTP helps improve performance of OLTP applications through efficient, memory-optimized data access, native compilation of business logic, and lock- and latch free algorithms. The In-Memory OLTP feature includes memory-optimized tables and table types, as well as native compilation of Transact-SQL stored procedures for efficient access to these tables."

Much like traditional tables, memory-optimized tables offer fully durable transactions and meet ACID (Atomic Consistent Independent and Durable) by default and are designed to help databases that require really fast performance.

Much like the name suggests, memory-optimized tables are stored in the main memory (RAM) and therefore not on the hard disk. In fact, internally, SQL Server does keep a second copy on disk but this is for durability purposes and is only read from the hard disk during database recovery. A set of checkpoint files...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Getting Started with SQL Server 2014 Administration

By : Gethyn Ellis

Getting Started with SQL Server 2014 Administration

By: Gethyn Ellis

Overview of this book

Memory-optimized tables

Getting Started with SQL Server 2014 Administration

By : Gethyn Ellis

Getting Started with SQL Server 2014 Administration

By: Gethyn Ellis

Overview of this book

Memory-optimized tables

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access