Tag: Monitoring

All About Automatically Monitoring Replication Agent Failures

ReplTalk Best Practices, Try This May 9, 2010

Vijay 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 is configured
Read More »

Transactional Replication Conversations

Chris Skorlinski [MSFT] Inside Replication, Troubleshooting February 21, 2010

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 »