Skip to Content
0
Jun 10, 2020 at 02:57 PM

ASE Sybase Resource Governor

173 Views Last edit Jun 10, 2020 at 02:59 PM 2 rev

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