In this episode of Data Exposed with David Pless and Anna Hoffman, we will walk through a quick overview of the storage engine improvements that improves performance and scalability such as tempdb improvements, advances in capacity management and maintenance, and enhancements to SQL Server scalability for systems with large memory and processing power.
0:00 Introduction
1:00 The next step for SQL Server
2:51 SQL Server 2022
4:19 tempdb Performance Critical for Scalability
7:01 Shrink DB With Low Priority
9:22 XML Compression
11:36 Accelerate Database Recovery Improvements
14:20 Current Buffer Pool Scan Operations
✔️ Resources:
Introducing SQL Server 2022:
https://www.microsoft.com/en-us/sql-server/sql-server-2022
What’s new in SQL Server 2022:
https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/what-s-new-in-sql-server-2022/ba-p/2922227
📝 SQL Server 2022 Preview Playlist: http://aka.ms/dataexposed-sqlserver2022
📌 Let's connect:
Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna
Twitter: David Pless, https://twitter.com/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
