August 13, 2007 at 9:07 pm
How to find exact duration taken by a transaction to completely transfer from publisher to distributer and then from distributer to subscriber. I am able to get latency in agent history but duration is showing a cummilative value from past history.
I even enabled history verbose level logging to 2 and also enabled OutputVerboseLevel logging.
CAn any one help on this?
August 13, 2007 at 9:56 pm
You can check the log history in replication, but not for one transaction.
August 13, 2007 at 10:10 pm
For Example I replicated 33000 rows at 10:00PM, 42000 rows at 10:30PM and 25000rows at 11:15PM.
All are being shown in single session of log reader agent history.
How can I calculate the time taken by first 33000 rows from publisher to subscriber?
I am not getting how to calculate time taken by each transaction?
August 14, 2007 at 10:09 pm
Have you checked out the information that performance monitor shows you - the performance object "SQL Server:Replication Dist." has a counter called "DistDelivered Trans/sec" which does sound like the information you are after
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply