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.
Question: What is the Difference Between sql_handle and plan_handle?
Answer: I was recently asked this question. Let us see the answer today.
When SQL Server uses TempDB when any query does not have enough memory to do its operation, it is called TempDB Spill. Let’s learn today.
I would talk about enhancement in SQL Server 2019 Configuration Manager. Let us learn how to enable lock paged in memory (LPIM).