
Replication needs better performance can anyone help or suggest
We have implemented a transactional push replication set between our
staging and production server. The reason this is in place is because
we load 1+ million rows daily including inserts, updates, and deletes.
When we did this on production alone it brought it to its knees !! and
we had to shut down the site each night due to performance cost. Now
we load the rows on a staging system and let replication push them up.
we found this to have a MUCH smaller impact........HOWEVER :-) we now
see times of 10-24 hours for this stuff to replicate. We added double
NICS to allow for bigger pipe. we' have max recognized cpu's and RAM.
we have these two boxes on there own private network. We tried to
currsor the records in and tried bulk loading them.. but we always get
the same results. How can we make it faster... we should be able to
load alot more then 1 million rows a day... and replicate as well!!!!
If more info is needed i will glady provide.
Joshua Goodstein