This article is contributed. See the original author and article here.
In this episode of Data Exposed with David Pless and Anna Hoffman, we will discuss the new SQL Server 2022 Buffer Pool Parallel Scan improvement. Buffer Pool parallel scan improves the performance of scan operations on large-memory machines by utilizing multiple CPU cores. Customers running SQL Server on large-memory machines will witness faster executions scenarios which were historically slower due to the serialized buffer pool scan. The parallel scan feature also improves the buffer pool scan performance of small databases residing on large-memory machines. Additionally, this improvement adds buffer pool scan diagnostics and telemetry for supportability.
Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.