Showing posts with label thereplication. Show all posts
Showing posts with label thereplication. Show all posts

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