How to set the query governor cost limit option (Enterprise Manager)
To set the query governor cost limit option
- Expand a server group.
- Right-click a server; then click Properties.
- Click the Server Settings tab.
- Under Server behavior, select or clear Use query governor to prevent queries exceeding specified cost.
- In the box, specify a nonzero, nonnegative value that the query governor will use to disallow execution of any query that has a running length exceeding that value.
(c) 1988-98 Microsoft Corporation. All Rights Reserved.