The scripts below and the video capture walkthrough setting up a Microsoft SQL Server Replication Distributor using SQL commands. As discussed in previous posting, the Distributor is a key role in Replication. It serves as a “cache” holding transactions for Transactional Replication and history tracking for all types of Replication. I’ve highlighted some of the
Read More »
Why does Microsoft SQL Support ask me all those questions? Why can’t they just show me how it work or fix the problem? Well wish it was that simple, but for us to help you we need to get the “big picture”. Below are some of the questions we ask and initial troubleshooting steps we’ll
Read More »
Tracer Tokens are a great way to monitor the flow of transactions from the Publisher to the Subscriber. These can be generated and tracked from SQL Server Replication Monitor or via TSQL commands. This post includes some of the common TSQL commands used to generate and track Tracer Tokens. Details can be found on SQL
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 »
The 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 to track
Read More »