March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training

SQL SERVER – Cached Data Per Object in Memory

March 31, 2021
Pinal Dave
SQL Performance
Buffer Pool, SQL DMV, SQL Memory, SQL Scripts, SQL Server

“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.

Read More
total data pages

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

May 28, 2020
Pinal Dave
SQL Tips and Tricks
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.

Read More
buffer pool

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.

Read More
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version