NETENGINE
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