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. If your system is overloaded with a busy tempdb, you can reduce contention […]