Share this PostHere 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
Read More »
Share this PostHere are some thoughts on using Transactional (or Peer-2-Peer) Replication Subscriber to support both REPORTING and DISATER RECOVERY. Normally “subscriber” target server would have different set of non-clustered indexes to support REPORTING capabilities. The Publisher’s indexes, check-constraints, triggers, etc, would only be added when Publisher goes down and the Subscriber comes online as
Read More »
Share this Post1) MaxBCPThreads (contributed by Sanjaya Padhi, Microsoft SQL Server Support) I found we can add in the below point to increase the perf of the snapshot application by the distribution agent by use of MaxBCPThreads parameter as mentioned in the article below. Please note this does not apply when Snapshot created using default
Read More »
Share this PostSatesh Yele | Microsoft SQL Server Support Quick collection of links for getting started with Transactional Replication. Transactional Replication http://msdn.microsoft.com/en-us/library/ms165720(SQL.90).aspx How Transactional Replication Works http://msdn.microsoft.com/en-us/library/ms151706(SQL.90).aspx Considerations for Transactional Replication http://msdn.microsoft.com/en-us/library/ms151254(SQL.90).aspx Replication Security Best Practices http://msdn.microsoft.com/en-us/library/ms151227(SQL.90).aspx Implementing Replication http://msdn.microsoft.com/en-us/library/ms151847(SQL.90).aspx SQL Server Replication (How Do I) http://msdn.microsoft.com/en-us/library/ms166348(SQL.90).aspx Configuring Distribution http://msdn.microsoft.com/en-us/library/ms151860(SQL.90).aspx How to: Configure Distribution (SQL
Read More »
Share this PostI’m posting a collection of SQL Server 2008 Merge Replication Best Practices. The material below includes text from SQL Books Online, other white papers, KB articles, web postings, and little from experience I gained working with SQL Replication for almost 15 years. The “best practices” below are in no particular order. My objective
Read More »