Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swekik
Posting Yak Master
126 Posts |
 Posted - 2008-12-16 : 23:10:18
|
| Hi Gurus, I have a transactional replication from prd server to rpt server .Distribution database is at subscriber .I traced the latency between the publisher-distributor (3 sec) & Distributor-Subscriber(35Minutes)using tracetokens .I didn't understand why it is taking lot of time to commit at the subscriber .How can i track how many transactions are commiting per second/minute ?Is there any storedproc ?How can i determine whats going wrong ?Thanks in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-17 : 10:36:11
|
| http://www.sqlservercentral.com/articles/Replication/62625/ |
 |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-12-17 : 11:25:57
|
| Thanks Sodeep ,How can we measure how many transactions per second ? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-17 : 11:40:28
|
| With Performance counters. |
|
|
|
|
|
|
Latency between Distributor and Subscriber