Share this PostChange Data Capture feature of SQL 2008 is based on Transactional Replication. CDC and Transactional Replication used the same internal stored procedure sp_replcmds to retrieve data updates from the transaction log. However, unlike Transactional Replication, CDC does NOT require the tables to have a unique index (or Primary Key). In fact CDC can
Read More »
Share this PostWe 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.
Read More »
Share this PostVijay Rodrigues | Microsoft SQL Server Support SQL Server Management Studio provides a way to monitor events, such as replication agent events, using alerts. SQL Server includes a set of predefined alerts for replication agents. If you would like to start the monitoring for replication agent failures, please follow below steps. The below
Read More »
Share this PostWhen 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
Read More »
Share this PostDuring performance troubleshooting we often need to look at difference between two different databases. We’ve used SQL Server Tablediff Utility for the data changes but doesn’t help with schema changes. For schema differences you can use Database Compare tool available for Visual Studio. How to: Compare the Data of Two Databases http://msdn.microsoft.com/en-us/library/aa833428.aspx Schema
Read More »