SQL Server Performance

Dsitribution Agent error

Discussion in 'Performance Tuning for SQL Server Replication' started by shalini.dba, Jan 15, 2008.

  1. shalini.dba New Member

    The query has been cancelled extimated cost of this query exceeds the configured threshold contact the system adminstrator.. This error occurs when running the distribution agent. What do you guys think resolution of this. I think it has to do something with the query governor cost limit on the subscriber side. any ideas throw it please Thank You.
  2. satya Moderator

    What kind of error, they will be many. In order to get quick solution post correct error you are getting.
  3. ghemant Moderator

    Hi,
    If am assuming correct please configure some higher value for QUERY_GOVERNOR_COST_LIMIT and see if this helps,also try to configure some higher value for batch size, and batch commit threshold.
    And as suggested by Satya please re-phrase your question...

Share This Page