Post reply

Replication Log Reader running slow

  • 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.

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply