Post reply

Volume of data sent thru transactional replication

  • August 11, 2004 at 8:51 am

    #86221

    We are seeing latencies in replication to a server across the Atlantic but not in the US. The network guys want to know the volume of data being sent whenever we observe latencies. Is there a quick way to say b/w 9pm - 10 pm , 100Mb of data was sent across the wire by replication ?

    Thanks

    -srini

  • August 12, 2004 at 6:05 am

    #518637

    No. The network folks will have to measure throughput, that's their job. You can tell them the number of commands by a query like this in your distribution database.

    select total_delivered_commands from

    MSdistribution_history,MSdistribution_agents  where agent_id=id

    and Subscriber='SubscriberServerName'

    Looking for a book on SQL Server replication?

    http://www.nwsu.com/0974973602.html

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply