Hi,
This is regarding the resource governor.
Resource Governor is mechanism to limit the resources a given process may request or acquire.
Below are the list of limit type available as part of resource governor.
row_count :- Limits the number of rows a query can return
elapsed_time :- Limits the number of seconds that a query batch or transaction can run
io_cost :- Limits either the actual cost or the optimizer’s cost estimate for processing a query
tempdb_space :- Limits the number of pages a tempdb database can have during a single session
Could you please let me know whether it will help us to limit the tempdb log space usage ? tempdb_space limit will help us for limit on tempdb data page not the log space. Could you please let me know your thoughts on this.
Thanks,
Uday