Episode
SQL Server 2022 Storage Engine Capabilities (Ep. 4) | Data Exposed
with Marisa Brasile, Anna Hoffman, David Pless
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.
Chapters
- 00:00 - Introduction
- 01:00 - The next step for SQL Server
- 02:51 - SQL Server 2022
- 04:19 - tempdb Performance Critical for Scalability
- 07:01 - Shrink DB With Low Priority
- 09:22 - XML Compression
- 11:36 - Accelerate Database Recovery Improvements
- 14:20 - Current Buffer Pool Scan Operations
Recommended resources
Related episodes
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.
Chapters
- 00:00 - Introduction
- 01:00 - The next step for SQL Server
- 02:51 - SQL Server 2022
- 04:19 - tempdb Performance Critical for Scalability
- 07:01 - Shrink DB With Low Priority
- 09:22 - XML Compression
- 11:36 - Accelerate Database Recovery Improvements
- 14:20 - Current Buffer Pool Scan Operations
Recommended resources
Related episodes
Have feedback? Submit an issue here.