July 2009 - Posts

• How Replication setting Immediate_sync may cause Transactional Replication Distribution database growth

  How Replication setting Immediate_sync may cause Transactional Replication Distribution database growth and long running cleanup. Distribution Cleanup for highly active servers with 60-100+ millions rows cached, database growth and cleanup will be an Read More... Posted Monday, July 27, 2009 3:50 PM by chrissk | 0 Comments

• Why is query performance of Replication Subscriber slower than Publisher?

  Time to compare indexes on Publisher vs. Subscriber. We encounter an unusual problem in SQL 2005/2008 where the indexes didn’t get created on the Subscriber when the Snapshot was pushed by the Merge Agent. Without critical indexes, query optimizer was Read More... Posted Monday, July 13, 2009 9:08 PM by chrissk | 0 Comments