SQL Server 2022 Storage Engine Capabilities (Ep. 4) | Data Exposed
source link: https://www.youtube.com/watch?v=VeK1OvBKZYI
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
SQL Server 2022 Storage Engine Capabilities (Ep. 4) | Data Exposed
346K subscribers
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-s... What’s new in SQL Server 2022: https://techcommunity.microsoft.com/t...
📝 SQL Server 2022 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
Show less
Show more
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK