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.

  • dedicated servers vs p2p, web hosting for students, dedicated server gaming, dedicated servers meaning, web hosting definition, web hosting google, linux vps, dedicated server hosting unlimited bandwidth, web hosting vs cloud hosting, dedicated server hosting USA, web hosting free, dedicated server minecraft, web hosting with free ssl, dedicated server hosting benefits, dedicated server vs shared hosting, dedicated server hosting advantages, vps hosting free, web hosting wiki, dedicated server ark, dedicated server vs vps, dedicated server hosting atlanta, web hosting vs wordpress hosting, dedicated server hosting comparison, wordpress hosting, dedicated server hosting asp.net, dedicated server hosting cheapest, dedicated server cloud hosting
  • 45748 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...

Powered by WHMCompleteSolution