SQL Memory Archives - Page 2 of 12 - SQL Authority with Pinal Dave

SQL SERVER – Total Data Pages In Memory Buffer Pool – sys.dm_os_buffer_descriptors

May 28, 2020

Buffer Pool, SQL DMV, SQL Index, SQL Memory, SQL Server

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

May 27, 2020

Pinal Dave

SQL Performance

Buffer Pool, SQL DMV, SQL Index, SQL Memory, SQL Server

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

May 15, 2020

Pinal Dave

SQL Performance

Execution Plan, In-Memory OLTP, SQL Memory, SQL Scripts, SQL Server, SQL 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

May 14, 2020

Pinal Dave

SQL Performance

Execution Plan, In-Memory OLTP, SQL Memory, SQL Scripts, SQL Server, SQL 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.