Replication Log Reader running slow

• dwilliscp

  SSCrazy Eights

  Points: 9270

  More actions

  May 4, 2017 at 10:28 pm

  #342759

  I have a database with a log file of 21G, that has a number of tables being replicated. How do I get the log reader to read the log quickly .. currently it is taking so long that the publisher's query (that is blocked by the log reader's spid) times out... the setting is the default 1800.

• Bart Lewandowski

  Ten Centuries

  Points: 1099

  More actions

  May 9, 2017 at 11:03 am

  #1941857

  Try to create new agent profile with bigger timeouts, readbatch and Logscan settings.

  Also check if there are any locks on distribution db as log reader may lock with distribution agents and cleanups. Check also autogrowth on distribution db (maybe u have default values autogrowth by 1 MB etc.)

  BartL
  Replication Blog