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 ...