Home Forums SQL Server 2008 SQL Server 2008 - General Concerns with Transaction replication parameters RE: Concerns with Transaction replication parameters

  • January 3, 2013 at 1:20 am

    #1573194

    foxxo (1/2/2013)

    Reduce your readbatchsize, it's too high which is why you're seeing the message:

    http://www.sqlservergeeks.com/blogs/Abhay_c/sql-server-bi/455/sql-server-fine-tuning-transactional-replication-performance-part-1

    I'm thinking of changing the readbatchsize parameter from 5000 to 1000. And see if that makes sense.

    I've read that changing Readbatchthreshold can cause very slow performance in 2008

    http://connect.microsoft.com/SQLServer/feedback/details/478792/using-the-readbatchthreshold-parameter-in-logreader-agent-leads-to-slow-performance

    This connect I think is for SQL 2008. Our's is SQLserver 2008 R2 Sp1. This issue would have been resolved. The date of the issue reported is also in 2009. I assume the issue would have been resolved in SQLserver 2008 R2. Thanks for answering the post.