Niko Neugebauer • 10/30/2019

Memory-Optimized TempDB Metadata

This technical article provides a deep dive into SQL Server's 'Memory-Optimized TempDB Metadata' feature. It explains how this feature addresses TempDB metadata contention by using in-memory technology, contrasting it with allocation page (GAM/SGAM) contention. The author includes setup instructions, sample stored procedure code, and details a stress test using RML utilities (ostress) to benchmark performance improvements on an Azure VM.

0 comments

#Database Optimization #SQL Server #In Memory