sql server replication: Monitoring replication performance -- sql server replication

Monitoring replication performance

Tõnu
5/12/2006 12:00:00 AM

sql server replication:

Hi!

Is there any way to find out which articles take time in merge replication
with dynamic filters. We added a number of tables to our replicable
database. The relation between the added tabels and existing ones is through
id filelds (primary key). Relations between the data form tree-like
structure, so we do not see any chances for cycles not complicated filter
conditions. Still after adding the tables the replication time increased
from 2 minutes to 40! From replication monitor we see, that delivery rate is
between 2-8 tems per second (which seems very slow). Is there any way to
find out about the individual queries behind replication and their execution
times?

Best regards,
Tonu

Re: Monitoring replication performance

Hilary Cotter
5/12/2006 12:00:00 AM

Yes, basically you create a logging table on your subscriber and modify
sp_MSsetupbelongs to including logging logic which will provide timings for
you. Follow the instructions on how to do this included in this link:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/mergproc.mspx#ESGAC

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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]