Glenn Boonen

07 May 2020 When tempdb becomes permanentdb

What can go wrong when you combine memory-optimized tempdb with the resource governor? If you are using SQL Server 2019 you’ll see that one of the new features allows you to convert some tempdb system tables in in-memory OLTP.