Groups | Blog | Home
all groups > sql server replication > february 2007 >

sql server replication : Replication Latency


Sal
2/20/2007 9:10:05 AM
Hi:

Latency is very high in replication monitor even though I don't see any
commands to be applied in sp_browsereplcmds. Do you know from where it gets
the latency number from in distribution database because it is misleading?

Sal
2/20/2007 1:15:34 PM
I can't find this table "MSreplication_monitordata" in distribution database.

[quoted text, click to view]
Hilary Cotter
2/20/2007 2:40:56 PM
IIRC it gets it from the table MSreplication_monitordata in the distribution
database.

--
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]

Hilary Cotter
2/21/2007 12:00:00 AM
You use the term replication monitor which is a tool in SQL 2005. What
version of SQL Server are you running?

--
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]

Sal
2/21/2007 5:49:02 PM
I am using sql server 2000. Please let me know

[quoted text, click to view]
jimkatsos NO[at]SPAM gmail.com
2/22/2007 3:22:18 PM

Don't forget to take into account the polling intervals of your
logreader and distribution agents. Even though theses agents seem to
run continuously they in fact do not. Check out BOL for the default
intervals. I think they are around 5secs. One way of reducing latency
is by reducing this refresh interval. Be careful though you need to
strike a balance between low latency and agent thrashing away trying
to get data all the time.

Regards,
Jim Katsos
http://jims-spanakopita.blogspot.com/
AddThis Social Bookmark Button