Hi all, i've an Import functionality that load an XML and import data by a stored procedure. I receive this error message "The query has been canceled because the estimated cost of this query (7205) exceeds the configured threshold of 2500. Contact the system administrator." How can i solve ?
You have to break down the query. The server looks at the query and calculates the time it expects the query to take, in this case it's almost three times the limit, so the query won't run. That number is seconds, so the server expects your query to take 2 hours. You can see why we'd have to limit that.
Hi all, I run locally my stored procedure: 'EXEC sp_MyNameOfStoredP @xml = @xml' without problem in few seconds. But if I run exactly the same in 'discountasp environment' I get the message: "The query has been canceled because the estimated cost of this query (7205) exceeds the configured threshold of 2500. Contact the system administrator." The estimated time (7205) is then wrong! Should I set something?
The environment on your local machine is quite different than the environment on a shared server, so the estimate isn't necessarily wrong. You might want to open a support ticket and let us take a look at it. We might be able to give you some insight. But those thresholds are usually a pretty accurate indicator.
