Haripriya Naidu digs into what’s new in SQL Server’s Resource Governor:
In this article, we’ll focus on how to control TempDB datafile growth using Resource Governor (RG).
- RG is disabled by default and available only on Enterprise edition.
- Until SQL Server 2022, RG could only manage user databases.
- Starting with SQL Server 2025, RG can now manage TempDB as well.
Click through for the demo and additional information.