SQL Server In-Memory OLTP

By Jason Brimhall , Wayne Sheffield

SQL Server In-Memory OLTP Cover Image

Learn all about the new support in SQL Server 2014 for in-memory online transaction processing, formerly code-named "Hekaton".

Full Description

  • ISBN13: 978-1-4302-6755-3
  • 250 Pages
  • User Level: Intermediate to Advanced
  • Publishing July 1, 2014
  • Print Book Price: $49.99
  • eBook Price: $34.99

Related Titles

Full Description

SQL Server In-Memory OLTP is your one-stop resource for learning all about the new support in SQL Server 2014 for in-memory online transaction processing. You are now able to create tables and other objects such as indexes that exist only in memory, and never on disk. This is a game-changing feature with ripple effects that extend across the domains of transaction management, performance optimization and scalability, and maintenance and troubleshooting, and and application development.


Formerly known under the code name of "Project Hekaton", in-memory support is the defining new feature of the 2014 release. Database administrators and application designers must become familiar with the feature in order to know when it is best used, and when it is best avoided. Use of in-memory tables and indexes can bring tremendous performance benefits, but then you must know how to manage those objects and how to write applications against them in an optimal manner. SQL Server In-Memory OLTP provides several reference architectures to help you see how in-memory objects can be implemented in different situations. You'll learn how to monitor and troubleshoot in-memory objects, and how to optimize their performance. You'll learn about programming caveats and transaction management.

Support for in-memory objects is a game changer, and their use must at least be considered in all new database and application design work, and when attacking problems of performance and scalability. It is a must-learn feature, and SQL Server In-Memory OLTP provides what you need to know swiftly, accurately, and succinctly.

What you’ll learn

  • Understand the in-memory architecture and its implications.
  • Create and manage tables and indexes using the new architecture.
  • Write applications and T-SQL procedural code to best take advantage of in-memory support.
  • Properly manage transactions under the new architecture.
  • Migrate to and from, and interoperate between, in-memory and on-disk tables.
  • Monitor and optimize performance improvements from in-memory objects.

Who this book is for

SQL Server In-Memory OLTP is a must-read book for SQL Server administrators and those who design and develop applications running against SQL Server databases. Professionals working closely with SQL Server need to understand the new, in-memory support and its benefits, to know when it should be used, and be able to monitor and optimize the systems that use it.

Table of Contents

Table of Contents

1. Introduction to In-Memory

2. Database Changes

3. Memory-Optimized Tables

4. Memory-Optimized Indexes

5. Natively-Compiled Stored Procedures

6. Interop Procedures

7. Transaction Isolation and Concurrency

8. Database Backup and Recovery

9. Dynamic Link Libraries

10. Management

11. Migration

Errata

Please Login to submit errata.

No errata are currently published