Purpose

The purpose of this article is to teach you the process of setting up the query governor cost limit option in Microsoft SQL Server 2000.

Setting up the Query Governor Cost Limit Option

Query governor cost limit option is used 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.

Following steps describe you the step by step details of setting up the query governor option:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

2. Right click the registered SQL Server i.e. PC54, and click Properties. Now, select the Server Settings tab.

3. Now, under Server behavior, select Use query governor to prevent queries exceeding specified cost: option, and set a value for it.

4. Click OK.