TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

SET QUERY_GOVERNOR_COST_LIMIT (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Overrides the currently configured query governor cost limit value for the current connection.

Topic link icon Transact-SQL Syntax Conventions

  
SET QUERY_GOVERNOR_COST_LIMIT value  

value
Is a numeric or integer value specifying the longest time in which a query can run. Values are rounded down to the nearest integer. Negative values are rounded up to 0. 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, and all queries are allowed to run indefinitely.

"Query cost" refers to the estimated elapsed time, in seconds, required to complete a query on a specific hardware configuration.

Using SET QUERY_GOVERNOR_COST_LIMIT applies to the current connection only and lasts the duration of the current connection. Use the Configure the query governor cost limit Server Configuration Optionoption of sp_configure to change the server-wide query governor cost limit value. For more information about configuring this option, see sp_configure and Server Configuration Options (SQL Server).

The setting of SET QUERY_GOVERNOR_COST_LIMIT is set at execute or run time and not at parse time.

Requires membership in the public role.

SET Statements (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft