Migrating to In-Memory OLTP

In-Memory OLTP is not necessarily a solution for every type of relational database performance problem. So when should you, or should you not, consider implementing In-Memory OLTP and what tables would make good candidates? The following scenarios are situations where you might be able to take advantage of the benefits of In-Memory OLTP.

Image Applications that are incurring high lock/latch contention can alleviate this contention by converting the tables where the contention is occurring from disk-based tables to memory-optimized tables.

Applications that are incurring high I/O and logging latency—In-Memory OLTP can help ...

Get Microsoft SQL Server 2014 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.