Today we will see an interesting story about Memory Optimized Tables, Transactions, Isolation Level and Error. Let us read the blog post.
Customer reached out me with a very simple but very interesting question related to Detecting Database Isolation Level MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT.
Question: How to List All Memory Optimized Tables in SQL Server? We will see two different scripts here: One for Database and Second for Tables.
During recent Comprehensive Database Performance Health Check, one of my customer asked if I can also help them to check their readiness of In-Memory OLTP Migration as well as the help them build a checklist which can help them with In-Memory OLTP Migration.
The whole concept of InMemory OLTP has been around for a while and still there are areas that I try to go back to learn every single time. If you are new to InMemory OLTP, I would highly recommend searching this blog for more content. For a starter, the blow blog is a great start.