Improve scalability with Buffer Pool Parallel Scan in SQL Server 2022


This blog post is part of the SQL Server 2022 blog series.

Buffer Pool Parallel Scan is a new feature in SQL Server 2022 that improves the scalability of several common scenarios in SQL Server and as a result, could significantly improve the performance of your database workloads.

The buffer pool and buffer pool scans

The buffer pool is the area of memory that SQL Server uses to cache data. All pages must be copied into the buffer pool before they can be used in a query, and it is necessary to scan the buffer pool for a number of operations.

Buffer pool scans