Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning The query has been canceled because the estimated cost of this query (3373) exceeds the configured threshold of 300 RE: The query has been canceled because the estimated cost of this query (3373) exceeds the configured threshold of 300

  • I had increased query cost to 1200, there was no difference... Now, even the sql's (using except) are not running in backend.

    So i have changed query governor setting to 0 and remote query timeout to 0 which seems to have solved teh problem...Am not sure if anyone has changed the query cost time,earlier...

    Thanks..