Ben Johnston in SQL Server When to enable memory-optimized tempdb metadata in SQL Server (and how to diagnose it) How to diagnose tempdb metadata latch contention in SQL Server - and decide whether enabling memory-optimized tempdb metadata is the... 08 January 2025 10 min read
Learn SQL Server Monica Rathbun in Learn SQL Server Mastering TempDB: The basics Mastering TempDB is a critical skills for SQL Server DBAs. In this article, Monica Rathbun explains the basics of TempDB... 26 January 2021 11 min read
Jonathan Kehayias Optimizing tempdb configuration with SQL Server 2012 Extended Events One of the most obvious bottlenecks in the performance of tempdb is caused by PAGELATCH, in-memory latch contention on the... 13 July 2012 20 min read
Brian Moran Tracking tempdb growth Runaway tempdb growth can be a problem, so how do you track its growth and correlate the growth to specific... 11 April 2005 4 min read
