Share this PostRishi Maini | Microsoft SQL Server Escalation Services All about “Not for Replication” “Not for Replication” is a property which can be set for different objects like Check constraints, Foreign Key constraints, Triggers , Identity columns etc while using SQL Server Replication. Feature used when the DBA would like the transactions to behave
Read More »
Share this Post Transactional Replication Conversations When troubleshooting Transactional Replication performance break down the flow of data into 4 simultaneous conversation. Examine performance of each conversation. This will help verify where the bottleneck investigation should begin. 1) LogReader Reader thread is reading the Transaction Log via stored procedure sp_replcmds, a wrapper for xp_replcmds. It scans
Read More »
Share this PostEric Burgess | Microsoft SQL Server Escalation Services You can programmatically setup and configure Merge Replication using Replication Management Objects (RMO). How to: Create a Pull Subscription (RMO Programming) http://msdn.microsoft.com/en-us/library/ms147314.aspx Replication in SQL Server Express http://msdn.microsoft.com/en-us/library/ms165700(SQL.90).aspx SQL Server Express does not include the SQL Server Agent, which is typically used to run replication
Read More »
Share this PostHigh 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
Read More »
Share this PostThe SQL Replication system table syssubscriptions contains one row per published article per subscriber. Notice the “virtual” subscriber. With the immediate_sync property is set to true, “virtual” subscriptions are created as placeholders for retaining generated snapshot (transactions). These “virtual” subscriptions are activated just like normal subscriptions by the Snapshot agent and are used
Read More »