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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-12 : 10:42:05
|
| David writes "In our testing SQL 2000 environment, I use transaction replication from publisher server A and pull approach for subscriber B. (both in LA)The problem is the speed in replication. On the publisher side, it was a prompt to update. To update a flagActive bit field for customerID 100 from publisher A, it took 8 seconds to replicate to subscriber B customerID 100. No errors at all, but it is not acceptable. In SQL 65, the same replication only took less than .5 second. (Publisher from LA, subscriber from NY)Any thoughts, how come the SQL2k replication could be slower than SQL65, with win2000 server vs. NT 4.0?All SQL 65 and SQL 2000 are allocated 256 mb memory with 2 cpus (333 MHz)2 SQL 65 servers with sp5, NT 4.0 sp6.2 SQL 2k servers with sp1, win2000 servers sp1.I have also tried use the push to server B, the result is also around 8 seconds. thanksDavid" |
|
|
|
|
|
Replication too slow on SQL2000?!