Today we will be discussing how to list Total Data Pages In Memory Buffer Pool with the help of sys.dm_os_buffer_descriptors.
We reached the point to investigate the data in memory for a single database. Here is the script to list all the database pages in SQL Server Buffer Pool.
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.