Sign in to confirm you’re not a bot
This helps protect our community. Learn more

SQL Server 2022: Introducing Buffer Pool Parallel Scan (Ep. 5) | Data Exposed

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
3.5K views 3 years ago #SQLServer #AzureSQL #SQLServer2022
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. 0:00 Introduction 0:53 Current Buffer Pool Scan Operations 3:30 SQL Server 2022 - Buffer Pool Parallel Scan 4:55 Buffer Pool Parallel Diagnostics 6:48 Buffer Pool Parallel Scan Performance Results 7:52 Demo ✔️ Resources: Operations that trigger a buffer pool scan may run slowly on large-mem …...more
...more
SQL Server 2022: Introducing Buffer Pool Parallel Scan (Ep. 5) | Data Exposed
68Likes
3,585Views
2022Feb 24
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. 0:00 Introduction 0:53 Current Buffer Pool Scan Operations 3:30 SQL Server 2022 - Buffer Pool Parallel Scan 4:55 Buffer Pool Parallel Diagnostics 6:48 Buffer Pool Parallel Scan Performance Results 7:52 Demo ✔️ Resources: Operations that trigger a buffer pool scan may run slowly on large-memory computers: https://docs.microsoft.com/en-us/trou... Introducing SQL Server 2022: https://www.microsoft.com/en-us/sql-s... What’s new in SQL Server 2022: https://techcommunity.microsoft.com/t... 📝 SQL Server 2022 Preview Playlist: http://aka.ms/dataexposed-sqlserver2022 📌 Let's connect: Twitter: Anna Hoffman,   / analyticanna   Twitter: David Pless,   / dpless   Twitter: AzureSQL, https://aka.ms/azuresqltw 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer #SQLServer2022

Follow along using the transcript.

Microsoft Developer

588K subscribers