Storage Allocation and Management for Memory-Optimized Tables 

6 min read

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

1 Comment

SQL Server 2014 In-Memory OLTP: Memory Management for Memory-Optimized Tables 

5 min read

Memory-optimized tables must fully reside in memory and can’t be paged out. Unlike disk-based tables where insufficient memory can slowdown an application, the impact to  memory-optimized tables upon encountering out-of-memory can be severe, causing  DML (i.e. delete, insert or update) operations to fail. While this adds a new dimension to managing memory, the application failure…Read more

5 Comments

IO Resource Governance in SQL Server 2014 

5 min read

Resource Governor was introduced in SQL Server 2008 to achieve predictable performance in a multi-tenant environment, to support mixed workload patterns, to provide mechanisms and tools to deal with runaway queries, and to enforce resource limits for CPU and memory. It enables customers to implement database consolidation or to configure their own database as a service….Read more

3 Comments

In-Memory OLTP: High Availability for Databases with Memory-Optimized Tables 

5 min read

Starting with SQL Server 2012, the new offering of AlwaysOn Availability Groups and AlwaysOn Failover Cluster  Instances (FCI) suite of features have enabled Tier-1 customers with mission critical applications to achieve their availability goals with SQL Server with an easy to deploy and manage solution. SQL Server 2014 builds on this success and offers enhanced…Read more

7 Comments

SQL Server 2014: Pushing the Boundaries of In-Memory Performance 

4 min read

This morning, during my keynote at the Professional Association of SQL Server (PASS) Summit 2013, I discussed how customers are pushing the boundaries of what’s possible for businesses today using the advanced technologies in our data platform. It was my pleasure to announce the second Community Technology Preview (CTP2) of SQL Server 2014 which features…Read more

10 Comments

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

6 min read

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

7 Comments

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

6 Comments

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

12 Comments