Transactional Replication Conversations

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 the transaction log
Read More »

Walkthrough Setting up a SQL 2008 Replication Distributor using TSQL Scripts

In this video •Configuring Distributor is first step in setting up SQL Server Replication •We verify Distributor is not configured •Walkthrough setting up SQL Replication Distributor using TSQL Scripts •Highlight of key parameters •Show how to generated Distributor TSQL commands automatically from SQL Server Management Studio Remember, you can double-click the video to view FULL
Read More »

The process could not execute ‘sp_repldone/sp_replcounters’

Anurag Sharma | Microsoft SQL Server Escalation Services Log Reader fails with below error message The process could not execute ‘sp_repldone/sp_replcounters’ on ‘SQLGUY’. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help: http://help/MSSQL_REPL20011 The log scan number (23:49:3) passed to log scan in database ‘PUBLISHER’ is not valid. This error may indicate data corruption or that the
Read More »

Walkthrough Setting up SQL 2008 Peer-2-Peer Replication

Sudharshan Prahallada, Microsoft SQL Replication Support team walks through setting up Peer-2-Peer Transactional Replication on SQL 2008.  You can view this video from the BLOG or double-click to open in YouTube.  He did a great job showing the Peer-2-Peer Wizard and explaining how it all comes together in a 5 minute video. For demonstration purposes
Read More »