Re: High CPU caused by Merge Agent

How big are your msmerge_tombstone and msmerge_contents? If they are large
you might want to prune them using sp_mergecleanupmetatdata

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:33724CA4-7C78-47DB-B5C8-10ABE8FE9A49@xxxxxxxxxxxxxxxx
SQL2005 Win2003 Server

Merge agent is causing a cpu spike on subscriber each time it fires.
Calling
sys.sp_MSenumgenerations90

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?

tia,
chris


.

Loading