Does SQL Server have Resource Quotas?

[pdalberth]

Is there a way to implement resource (disk, memory, elapsed cpu time) quotas on a per account basis in SQL Server 7 or SQL 2000?

For example, can I protect my production environment from a poorly written query by configuring SQL Server to terminate any query that runs for more than 10 minutes?

Thanks in advance.

- pd

 

[tlbroadbent]

There is no way to limit resource usage by account. SQL 7 and 2000 have a "query governor cost limit" but it is set at the server level.

SQL 2000 Books Online: query governor cost limit Option

Use the query governor cost limit option to specify an upper limit for the time in which a query can run. Query cost refers to the estimated elapsed time, in seconds, required to execute a query on a specific hardware configuration.

If you specify a nonzero, nonnegative value, the query governor disallows execution of any query that has an estimated cost exceeding that value. Specifying 0 (the default) for this option turns off the query governor. In this case, all queries are allowed to run. Terry

;-) USER, n.: The word computer professionals use when they mean "idiot." -Dave Barry

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm