Tag: MSmerge_sessions

Challenges running Continuous Merge Agents

Chris Skorlinski [MSFT] Best Practices August 14, 2016

Chris SkorlinskiMicrosoft SQL Server Escalation Services I wanted to cover in this blog challenges you’ll encounter running Merge Agent on continuous schedule. These are Merge Agents whose SQL Server Agent jobs schedule are set for “Start automatically when SQL Server Agent starts”. Each time a Merge Agent starts it logs start time in
Read More »

Tracking Merge Agent Performance using Distribution database system tables

ReplTalk Troubleshooting March 16, 2010

Amit Banerjee | Microsoft SQL Server Support TSQL Code: MS_MergeAgentStatistics.sql script located on SkyDrive MergePerformance or TechNet Code Share I have sometimes found the need to track the performance of the Merge Agents configured on the server without having to dig through the Replication Monitor or through the Merge Agent job history outputs. So, here
Read More »