latency

Can someone please describe what this is and how I adjust my dist cleanup
agent retention times for it.
I know the basics, but when I go into MSdistribution table there are alot of
fields that seem similiar (ie: current_delivery_rate,
current_delivery_latency, delivery_rate, delivery_latency). Can someone
please explain the differences between these? And also how I can look at
bottlenecks that are increasing the latency and how do I find out my average
latency time for a specified period to valid the improvements?
Thanks,
K
P.S. I just received HC's book, so if someone could direct me to a location
in there, that would be fine too.
Latency is the average amount of time required for a transaction to be
applied on the subscriber after it has been applied on the publisher.
Current_delivery_rate is the Average number of commands delivered per second
since the distribution agent last ran. Current_delivery_latency is the
Latency between the command entering the distribution database and being
applied to the Subscriber since the last history entry.
If your Distribution agent runs in intervals or is scheduled latency can be
lengthy.
delivery_rate is average commands per second.
Recall that a transaction applied on the publisher is broken down to
singletons. So that a transaction which updates 100 rows will be transformed
into 100 update commands. So if you have a lot of singleton transactions
your delivery rate will be higher than if you have a lot of batch processes
which will mean a higher number of commands and a lower delivery rate.
Delivery_latency is Latency between the command entering the distribution
database and being applied to the Subscriber.
So, the lower your polling interval and if your distribution agent is
running continuously these values should be the same.
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
"Kristy" <pleasereplyby@.posting.com> wrote in message
news:Ocmi8LBJFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Can someone please describe what this is and how I adjust my dist cleanup
> agent retention times for it.
> I know the basics, but when I go into MSdistribution table there are alot
of
> fields that seem similiar (ie: current_delivery_rate,
> current_delivery_latency, delivery_rate, delivery_latency). Can someone
> please explain the differences between these? And also how I can look at
> bottlenecks that are increasing the latency and how do I find out my
average
> latency time for a specified period to valid the improvements?
> Thanks,
> K
> P.S. I just received HC's book, so if someone could direct me to a
location
> in there, that would be fine too.
>