ASE Sybase Resource Governor

[former_member575448]

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

[former_member89972]

Documentation does not say data or log for tempdb_space limit.

E.g. what happens when you have tempdb in "mixed" mode like master (data + log together) .

Try the test suggested by Brett and share your findings.

Avinash

[former_member188958 · Accepted solution]

You can test that by creating a table with a single row.
Begin a transaction and within an infinite loop, update that row repeatedly.
This will generate log records, but not use up any more data space.

Either the resource limit will fire, or you will run out of log space.