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.
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
