Let Resource Governor control tempdb usage
On a system with many different systems and ad-hoc requests it is not enough
to control memory and cpu. Even RG can control IO too, it's not much help if IO is not the bottleneck on fast SAN.
But crazy code can results in hundreds of Gb's tempdb usage.
I would like to define particular resource group only to consume limited amount of tempdb (quota).
tempdb is shared resource and scale-out (on other servers) not is an easy task, if the system not was designed that way from the beginning.
Oleg Goldberg commented
It would be a great feature helping with runaway user queries and avoiding application downtime.