Topic: OLTP database management

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

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 due to resource errors is not something new.

SQL Server 2014 In-Memory OLTP: Nonclustered Indexes for Memory-Optimized Tables 

SQL Server 2014 CTP1 introduced hash indexes for memory-optimized tables. Hash indexes are very efficient for point lookups, when you know exactly the value you are looking for. However, they do not perform well if you need a range of value, for example a date range, or if you need to retrieve the rows in a particular order.

The 411 on the Microsoft SQL Server 2014 In-Memory OLTP Blog Series 

This summer we started blogging about all of the innovation in the products that make up the Microsoft Cloud OS vision.  We’ve talked about Windows Server 2012 R2, Windows Azure and of course Microsoft SQL Server 2014.  In the case of SQL Server 2014, we did a series of posts over the past few months on In-Memory OLTP.