Replication Latency

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?
Thanks
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
"Sal" <Sal@.discussions.microsoft.com> wrote in message
news:ACB19921-E431-4DDE-A7EB-F2D1935E84D3@.microsoft.com...
> 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?
> Thanks
|||I can't find this table "MSreplication_monitordata" in distribution database.
"Hilary Cotter" wrote:

> 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
>
> "Sal" <Sal@.discussions.microsoft.com> wrote in message
> news:ACB19921-E431-4DDE-A7EB-F2D1935E84D3@.microsoft.com...
>
>
|||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
"Sal" <Sal@.discussions.microsoft.com> wrote in message
news:565FB679-582F-4933-9E9D-F9CE558EACEA@.microsoft.com...[vbcol=seagreen]
>I can't find this table "MSreplication_monitordata" in distribution
>database.
> "Hilary Cotter" wrote:
|||I am using sql server 2000. Please let me know
"Hilary Cotter" wrote:

> 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
>
> "Sal" <Sal@.discussions.microsoft.com> wrote in message
> news:565FB679-582F-4933-9E9D-F9CE558EACEA@.microsoft.com...
>
>
|||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/