About this episode

Guy and Eitan discuss SQL Server performance tuning best practices and considerations for upgrading to SQL Server 2025.

Guy and Eitan go over Paul Randal's article of "Top Ten SQL Server Performance Tuning Best Practices" (published in last March), and add their own input. We also talk about considerations of upgrading SQL Server to 2025, and we also learn something new about Temp Table Caching. Relevant links: SQL101: Top Ten SQL Server Performance Tuning Best Practices - Paul S. Randal SQL Server 2016 Extended Security Updates: Stay Protected While You Modernize | Microsoft Community Hub Memory-optimized TempDB metadata | Microsoft Learn Limitations of Memory-optimized TempDB metadata | Microsoft Learn SQL Server 2022 addresses GAM and SGAM contention in TempDB Temporary Table Caching Explained SQL Server Temporary Object Caching

People in this episode

Hosts: Guy Glantser, Eitan Blumin

Topics covered

• SQL Server performance tuning
• upgrading SQL Server
• Temp Table Caching
• best practices
• database management

Keywords

• SQL Server
• performance tuning
• Temp Table Caching
• best practices
• upgrading SQL Server

Mentioned in this episode

Organizations: Microsoft Community Hub, Microsoft Learn, SQL Server

Explore listener stats, chart rankings, contacts and more on the SQL Server Radio podcast page.