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 |
|
rushdib
Yak Posting Veteran
93 Posts |
 Posted - 2008-06-25 : 11:52:50
|
| Hi,We are using merge and transactional replication with a publisher / distributor and 2 subscribers. We never had a performance issue for the past 3-4years but now all of a sudden it has become extemely slow. If I transfer the data using DTS directly then I don't find any performance issue. Where do I start looking for a clue?Thanks,Rushdi |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-25 : 12:36:03
|
| Track the transaction latency using trace token.Check if there is blocking involved?http://sql-server-performance.com/tips/transactional_replication_p1.aspx |
 |
|
|
rushdib
Yak Posting Veteran
93 Posts |
Posted - 2008-06-27 : 09:07:49
|
| We found the problem. The ODBC tracing was set on the server by the network admin. Once the tracing stopped, everything went back to normal. |
|
|
|
|
|
|
replication performance hit