Microsoft SQL Server 2014: In-Memory OLTP Performance Troubleshooting
Play Microsoft SQL Server 2014: In-Memory OLTP Performance Troubleshooting
You've migrated parts of your application to in-memory. But now you are not seeing a serious performance improvement, or maybe even a performance degradation! What's going on? In this session we walk you through several performance problems we have seen with customers, and show how to diagnose and resolve the issues to ultimately obtain the performance improvement you're looking for from in-memory OLTP. We address a variety of issues, including log IO bottlenecks, index tuning, and query plan problems.