Skip to content
SQL Server Blog

Storage Allocation and Management for Memory-Optimized Tables 

As described in implementing durability for memory optimized tables, the storage requirements and its management for memory optimized tables is very different compared to the disk-based tables. If you are migrating a subset of your disk-based tables to memory-optimized tables or are just developing a new application with memory-optimized tables, you will notice these differences....Read more

SQL Server 2014 In Memory OLTP: Memory-Optimized Table Types and Table Variables 

SQL Server 2014 In-Memory OLTP introduces two new widely advertised kinds of database objects: memory-optimized tables for efficient data access, and natively compiled stored procedures for efficient query processing and business logic execution. However, there is a third kind of object introduced by In-Memory OLTP: the memory-optimized table type. The use of memory-optimized table variables...Read more

New In-Memory OLTP Sample for SQL Server 2014 CTP2 

To help you get started with the new In-Memory OLTP feature, we created a sample around sales order processing based on the AdventureWorks sample database. The sample, along with installation and usage instructions, are available on Codeplex: https://msftdbprodsamples.codeplex.com/releases/view/114491 We encourage you to download and install the sample to become familiar with the new memory-optimized tables...Read more

In-Memory OLTP: How Durability is Achieved for Memory-Optimized Tables 

In-memory OLTP provides full durability for memory-optimized tables. When a transaction that has made changes to memory-optimized table commits, SQL Server, just like it does for disk-based tables, guarantees that the changes are permanent and can survive the database restart provided the underlying storage is available. There are two key components of durability. First is...Read more

Concurrency Control in the In-Memory OLTP Engine 

We believe that the In-Memory OLTP engine advances the industry state of the art with respect to concurrency control. The main reason for this advancement is due to the combination of lock free algorithms and the row-versioned architecture of the engine. This post examines what we precisely mean when we describe the In-Memory OLTP engine...Read more

Solving Session Management Database Bottlenecks with In-Memory OLTP 

As we started working with early adopters on the SQL Server 2014 In-memory OLTP engine (project codenamed Hekaton) one of the first scenarios we ran into involved a session management database in SQL Server. The application was a high volume website storing ASP.net Session State in the database and running into latch contention and locking...Read more

Improved Application Availability During Online Operations in SQL Server 2014 

SQL Server 2014 introduces enhancements to two common database maintenance operations namely Partition Switching and Online Index Rebuild which greatly increases enterprise application availability by reducing maintenance downtime impact. The following features are available in SQL Server 2014 CTP1 which can be downloaded here: Managed Lock Priority for Table Partition Switch & Online Index Rebuild...Read more

SQL Server 2014 In-Memory OLTP: App Migration Scenario Leveraging the Integrated Approach 

As we emphasized in the previous blogs, with other in-memory technologies in the market today you have to migrate the entire database to memory or it’s a separate database product that deals with in-memory, which means learning new APIs and dealing with application compatibility issues. Integrating in-memory technology right into the SQL Server engine might...Read more

How Memory-Optimized Database Technology is Integrated into SQL Server 2014 

SQL Server 2014 takes an integrated approach to in-memory database technology. In-Memory OLTP, which optimizes performance of OLTP workloads, is fully integrated in the core SQL Server relational database management system. Now, what do we mean by “fully integrated”? In this post we highlight some of the aspects that demonstrate: Installation No special steps are...Read more

Hardware Considerations for In-Memory OLTP in SQL Server 2014 

In-Memory OLTP uses memory and disk in different ways than traditional disk-based tables. The  performance improvement you will see with In-Memory OLTP depends the hardware you use. In this blog post we discuss a number of general hardware considerations, and provide generic guidelines for hardware to use with In-Memory OLTP. CPU In-Memory OLTP does not...Read more