High CPU caused by Merge Agent -- sql server replication

Chris
12/23/2006 10:17:00 AM

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,

Hilary Cotter
12/23/2006 9:38:28 PM

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

[quoted text, click to view]

sql server replication : High CPU caused by Merge Agent