When tempdb becomes permanentdb
What can go wrong when you combine memory-optimized tempdb with the resource governor? In-memory tempdb metadata 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.
