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 »
We recently need to find all the difference in data between 2 SQL Servers each with 300 SQL replicated tables. To find the differences, we were planning on using the TableDiff utility included with SQL 2005 which is a command line tool designed to provide TSQL needed to manually sync two table in two different
Read More »
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 »
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 »
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 »