High CPU caused by Merge Agent

#1

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

#2

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 (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

High CPU caused by Merge Agent

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication

High CPU caused by Merge Agent - 12-23-2006 , 12:17 PM

Re: High CPU caused by Merge Agent - 12-23-2006 , 08:38 PM