He asked me if I can provide it scientifically my findings and he will immediately approve the budget. Let us see Queries Waiting for Memory Grant.
Why SQL Server Doesn’t Give the Memory Back to OS?
Today’s post is written by SQL Server Expert Brian Gale. Why SQL Server Doesn’t Give the Memory Back to OS? Let us learn an amazing concept.
SQL SERVER – Total Data Pages In Memory Buffer Pool – sys.dm_os_buffer_descriptors
Today we will be discussing how to list Total Data Pages In Memory Buffer Pool with the help of sys.dm_os_buffer_descriptors.
SQL SERVER – Data Pages In Memory Buffer Pool – 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.
SQL SERVER – List All Memory Optimized Tables in TempDB
I received a very interesting question from my client. The question was about how to list all the Memory Optimized Tables in TempDB.
SQL SERVER 2019 – Memory-Optimized TempDB and RESOURCE_SEMAPHORE Wait Type
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.
What is the Difference Between sql_handle and plan_handle?- Interview Question of the Week #269
Question: What is the Difference Between sql_handle and plan_handle?
Answer: I was recently asked this question. Let us see the answer today.