May 4, 2017 at 10:28 pm
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy