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

In-Memory OLTP Programmability: Concurrency and Transaction Isolation for Memory-optimized Tables

The new In-Memory OLTP feature introduces memory-optimized tables and natively compiled stored procedures in SQL Server 2014, to optimize performance and scalability of OLTP workloads. To benefit from this technology in an existing SQL Server application, you need to migrate the performance critical tables and stored procedures to memory-optimized tables and natively compiled stored procedures… Read more

New AMR Tool: Simplifying the Migration to In-Memory OLTP

As we have addressed in previous blog articles, the transition into SQL Server In-Memory OLTP is not as simple as flipping a switch. One of the design principles of In-Memory OLTP is that you would only need to make surgically precise migrations for your app to reap the most benefit from In-Memory OLTP for the… 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