“How to build a list of cached data per object in memory pool?” I just received this question from my client who hired me for Health Check.
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.