Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Smile Unanswered: SQL Server 2000: Replication Latency health check

    Hi Everybody,
    Can anybody tell me how to get the number of commands delivered per minute in case of Merge Replication with Publisher and subscribers.
    This way, we can be sure that even if there is a latency (due to high volume transaction processing), replication is in good shape and things will catch up soon.
    Also if there are any other similar measures which can be monitored to make sure that replication is going on fine, it would be great

    Please let me know If anyone has got information on same.

  2. #2
    Join Date
    Jan 2003
    Nottinghamshire, UK

    Delivery of updates ROWS per second can be seen in EM - Replication Monitor - Merge Agent Column called delivery per Second

    Theres also loads of pre-defined SQL replication monitors in NT Performance Monitor on the SQL Box

    I generally monitor replication the other way round and get notified only when there is something wrong then an alert is fired

    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts