8 – Limiting TempDB Usage with Resource Governor

SQL Server 2025 added the ability to cap how much TempDB space is used by all users, or by groups of users, applications, or databases. Let’s demo how it works by creating a denial-of-service attack against our own server, then explain how you have to configure TempDB for the limits to be enforced.

To access this incredible, amazing content, you gotta get Recorded Class Season Pass or Fundamentals of TempDB, or log in if you already shelled out the cash.

SQL Server 2025 added the ability to cap how much TempDB space is used by all users, or by groups of users, applications, or databases. Let’s demo how it works by creating a denial-of-service attack against our own server, then explain how you have to configure TempDB for the limits to be enforced.

To access this incredible, amazing content, you gotta get Recorded Class Season Pass or Fundamentals of TempDB, or log in if you already shelled out the cash.