High CPU caused by Merge Agent - 12-23-2006 , 12:17 PM
SQL2005 Win2003 Server
Merge agent is causing a cpu spike on subscriber each time it fires. Calling
This just started. Merge has been running well for about 1 month. Merge
agent fires on 1 minute schedule, normal execution time is about 20-40
seconds. Now it is taking almost 2 minutes to execute. Have about 30 tables
in merge, 10 of which have about 1+Mill records.
Is there a maintenance step I am missing?
Re: High CPU caused by Merge Agent - 12-23-2006 , 08:38 PM
How big are your msmerge_tombstone and msmerge_contents? If they are large
you might want to prune them using sp_mergecleanupmetatdata
Looking for a SQL Server replication book?
Looking for a FAQ on Indexing Services/SQL FTS
"Chris" <Chris (AT) discussions (DOT) microsoft.com> wrote