Here is a quick list of CDC Best Practices. Search “CDC” tags for other BLOG posting on designing, supporting and troubleshooting CDC. These recommendation come from various sources including the MSDN CDC White Paper, a recommended read for anyone interesting in tuning CDC performance. Recommendation: Try to avoid scenarios where a row needs to be
Read More »
The Microsoft Knowledge Base contains the following article for setting up a SQL 2000 Subscriber using Backup/Restore. Once the subscriber is restored sp_scriptpublicationcustomprocs is executed to create the subscriber Replication SPs. 320499 How to manually synchronize replication subscriptions by using backup or restore http://support.microsoft.com/default.aspx?scid=kb;EN-US;320499 These steps should be modified for SQL 2005/2008 which automatically creates
Read More »
In the middle of a huge phased migration from SQL 2000 to SQL 2008 we noticed the SQL 2008 publisher\distributor was causing blocking when replicating data changes to the SQL 2000 subscriber. We discovered the SQL Server 2005\2008\2012 Distribution Agent was configured to replicate as native SQL commands instead of default parameterized stored procedures. This
Read More »
Anurag Sharma | Microsoft SQL Server Escalation Services Background In many cases customer often have large databases published and creating a snapshot of such large database is always a pain. And, even when published databases are of manageable size, a slow or unreliable network link can further complicate the issue. From SQL Server 2005 onwards
Read More »
High Level Transactional Replication Process Flow I’ve posted this flow before on my BLOG but I wanted to include the stored procedure calls used by Transactional Replication. While troubleshooting Replication performance/latency we’ll try and identify which stored procedure executing from which Replication Agent has the highest IO or highest CPU usage. These usually are a
Read More »