Tag: sp_MShistory_cleanup

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 »

How to change the SQL Replication Agent History Cleanup Job

Chris Skorlinski [MSFT] Inside Replication, Troubleshooting August 17, 2010

By default the SQL Replication Agent History cleanup job runs every 10 minutes and deletes any historical data older the 48 hours. If you’re only running SQL Server Replication Agent a few times each day, you can reduce the frequency of this cleanup job and increase the retention period for historical data without impacting SQL
Read More »