May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • 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
buffer-pool-scans

SQL Server 2022: Buffer Pool Scans on Large-Memory Computers

May 29, 2023
Pinal Dave
SQL Performance
Buffer Pool, SQL Memory

Buffer pool scans causing slow operations on large-memory computers have long been a concern for SQL Server users.

Read More
Buffer Pool Scan

SQL Server 2022 Performance – Buffer Pool Scan

May 24, 2023
Pinal Dave
SQL Performance
Buffer Pool, SQL Memory, SQL Server 2022

One aspect that can significantly impact performance is scanning the buffer pool in Microsoft SQL Server. This blog explores buffer pool scan.

Read More

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 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version