We noticed a large published database was taking a long time for the Snapshot to be applied to the subscriber. Looking further in sp_who and sys.sysprocesses we noticed only one Distribution Agent thread executing the bulk insert statements. It took a while but we discovered the publication was created using “concurrent snapshot” option. -MaxBcpThreads number_of_threads
Read More »
When creating a Transactional Replication publication, what happens if I check Create a snapshot immediately and keep the snapshot available to initialize subscriptions? This sets the publication property @property=‘immediate_sync’,@value=‘TRUE’ which instructs Replication to keep all the transactions cached in the Distribution database for the entire Retention Period. Normally these rows are purged as soon as
Read More »
SQL Replication allows you to replicate user-defined Stored Procedures code to subscribers similar to replicating tables. When the sp is modified, the new schema/script is transferred to the subscriber. This ensures all subscribers have the most recent version of the SP. Transactional Replication also allows you to setup a subscriber using a backup of the
Read More »
I meet with a customer today planning for Peer-2-Peer Replication in conjunction with Microsoft Amalga, our Hospital Information System solution. I thought others would benefit from some of the Q&A that were raised in this meeting. I hope you too find these helpful in your projects. 1. How to monitor replication? >>>Tracer Tokens can be
Read More »
I’m developing in-depth training on Change Data Capture and created this BLOG posting as a reference for BOL topics and Web links I found helpful while researching CDC. I’ll update this posting with more links as time goes by. I hope you too find these helpful. Basics of Change Data Capture (great chart and overview
Read More »