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

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

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

Jetzt kostenlos hören, ohne Abo

Details anzeigen

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
adbl_web_anon_alc_button_suppression_t1
Noch keine Rezensionen vorhanden