TempDB is a natural fit for memory-optimized technology in SQL Server. The data within TempDB is 100% transient, vanishing when no longer needed or when a restart occurs.
As a common bottleneck for intermediary operations, TempDB’s contention can be broken into data and schema contention. Memory-Optimized TempDB Metadata moves some of the most common system tables for temporary objects into memory. This eliminates latching on these tables while greatly reducing or eliminating waits on them.
This feature is an easy win that requires little memory and can greatly improve SQL Server performance where TempDB is a common bottleneck. In ten minutes we will discuss how it works, how to use it, and why it is worth using!
Sign up to stay up to date with news, special announcements and educational content.
Redgate will only contact you about PASS Data Community Summit (in line with our Privacy Policy) unless you separately request emails about Redgate. You can unsubscribe from these updates at any time.
Summit video library