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

  • Hello,

    Is it possible that somebody e.g. a SQL Server Administrator, has recently changed the query governor cost limit?

    I am just wondering why your job was working before, and not now. Have there been any other major changes on the Server e.g. a large increase in data volume or removal of indexes that might cause the job to run a lot longer than before?

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group