Wednesday, March 7, 2012

rep monitor setup scripts

how to you measure Latency in pull or push sub/publist architecture?
Do you have a set of scripts which use to monitor and setup the
replication environment?
If you are using SQL Server 2005 and transactional replication, please take a
look at the tracer token functionality:
http://www.replicationanswers.com/TracerTokens.asp
If not, please post back with SQL Server version and type of replication.
Rgds,
Paul Ibison
|||On Apr 30, 10:26 am, Paul Ibison <Paul.Ibi...@.Pygmalion.Com> wrote:
> If you are using SQL Server 2005 and transactional replication, please take a
> look at the tracer token functionality:http://www.replicationanswers.com/TracerTokens.asp
> If not, please post back with SQL Server version and type of replication.
> Rgds,
> Paul Ibison
We using sql 2000. please tell me for that
|||Have a look at the counters for these two processes namely the SQL Server
Replication LogReader: Delivery Latency counter and the SQL Server
Replication Dist.: Delivery Latency counter. Also the treplication monitor
reveals similar info
(http://www.informit.com/articles/article.asp?p=170748&rl=1).
Rgds,
Paul Ibison

No comments:

Post a Comment