Earlier I wrote about SQL SERVER – SQLOS Scheduler and the Process States, lots of people liked the blog post and asked me another question – What is Latch?
A very popular question we will answer today Where are Table Variables Stored? Recently I have posted a few videos on my YouTube Channel,
This time DBA called me as he wanted to know if how to confirm that lock pages in memory is enabled for the SQL Server instance.
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.
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.
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.