The query has been canceled because the estimated cost of this query () exceeds the configured threshold.

Error:

The query has been canceled because the estimated cost of this query () exceeds the configured threshold of 1000. Contact the system administrator.

Cause:

QUERY_GOVERNOR_COST_LIMIT - Is a numeric or integer value specifying the longest time in which a query can run. "Query cost" refers to the estimated elapsed time, in seconds, required to complete a query on a specific hardware configuration.

Resolution:

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

SET QUERY_GOVERNOR_COST_LIMIT 6000

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

Note: increasing the query governor cost is not a good solution, we would recommend to pay more attention to sql statement.
  • MS SQL 2012, estimated cost of this query, The query has been canceled because the estimated cost of this q, threshold
  • 307055 Users Found This Useful
Was this answer helpful?

Related Articles

The timeout period elapsed prior to obtaining a connection from the pool

Error:"Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool....

Powered by WHMCompleteSolution