sp_Blitz: if Resource Governor is set to cap TempDB space usage, make sure TempDB files are configured correctly #3721
Description
Is your feature request related to a problem? Please describe.
SQL Server 2025 adds the ability to cap how much space a group uses in TempDB. It can either be configured via fixed size amount in MB, or by percentage. However, the limits only go into effect if your TempDB files are all configured appropriately for your cap (MB vs percent).
Documentation on when the limits actually work: https://learn.microsoft.com/en-us/sql/relational-databases/resource-governor/tempdb-space-resource-governance
Describe the solution you'd like
If RG is configured to cap TempDB space utilization, make sure their TempDB data file config will support it.
Are you ready to build the code for the feature?
Yep!