Skip to content
Episode 189 - Top Ten SQL Server Performance Tuning Best Practices and More episode artwork

Jul 6, 2026 39 min

Episode 189 - Top Ten SQL Server Performance Tuning Best Practices and More

from SQL Server Radio

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

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Episode 189 - Top Ten SQL Server Performance Tuning Best Practices and More

0:00 39:01

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of SQL Server Radio?

This episode is 39 minutes long.

When was this SQL Server Radio episode published?

This episode was published on July 6, 2026.

Can I download this SQL Server Radio episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.