My client of Health Check sent me an email asking if there is any other method when we have to attach an In-Memory Database with T-SQL.
I received a very interesting question from my client. The question was about how to list all the Memory Optimized Tables in TempDB.
After looking at the execution plan, I realized it was actually built for a very simple query. Today let us discuss Memory-Optimized TempDB and Performance.
Recently I had to work with a client for whom I have to build a script for Listing All Memory Optimized Files with Logical Name and Physical Name.
One of the customers of Comprehensive Database Performance Health Check asked me if I can help them analysis their database for In-Memory OLTP Migration.