Home Forums SQL Server 2008 SQL Server 2008 - General Transactional Replication Performance Issues After Migration From 2000 to 2008 RE: Transactional Replication Performance Issues After Migration From 2000 to 2008

  • chris.roddis-ferrari (11/14/2013)


    Only differences are BCPBatchSize and QueryTimeout which we haven't changed and PollingInterval which changed to 5 by default and we have changed back to 10

    None of those would make any difference to command delivery. Have you checked for blocking on distribution db and subscription db?

    Checked latency using a tracer token?

    These are the parameters which modify delivery rate.

    [-CommitBatchSize commit_batch_size]

    [-CommitBatchThreshold commit_batch_threshold]

    [-MaxDeliveredTransactions number_of_transactions]

    [-PacketSize packet_size]

    [-SubscriptionStreams [1|2|...64]]