Concurrency Control in the In-Memory OLTP Engine 

6 min read

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 

3 min read

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 

4 min read

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 

4 min read

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 Session State in the database and running into latch contention and locking Read more


Improved Application Availability During Online Operations in SQL Server 2014 

8 min read

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