Episode

System Page Latch Concurrency Enhancements (Ep. 6) | Data Exposed

with Marisa Brasile, Anna Hoffman, David Pless

Data Exposed

Over the past several SQL Server releases Microsoft has improved the concurrency and scalability of the tempdb database. Starting in SQL Server 2016 several improvements address best practices in the setup process, i.e. when there are multiple tempdb data files all files autogrow and grow by the same amount. Additionally, starting in SQL Server 2019 we added the memory optimized metadata capability to tempdb and eliminated most PFS contention with concurrent PFS updates. In SQL Server 2022 we are now addressing another common area of contention by introducing concurrent GAM and SGAM updates.

Chapters

  • 00:00 - Introduction
  • 02:21 - tempdb Performance Critical for Scalability
  • 03:48 - What is stored in tempdb?
  • 06:30 - Traditional tempdb Best Practices
  • 07:40 - tempdb Performance Critical for Scalability
  • 13:54 - Demo: System Page Latch Concurrency Enhancements
  • 19:45 - Getting started

Connect

SQL Server