Is replication a good solution? -
07-21-2005
, 02:12 AM
I have cubes that have multiple partitions, the fact tables of the partitions
are located on eight servers. So the dimension tables are copied across the
eight servers too.
However, the dimension table data is out of synchronized from time to time
for various reason. Is replication a good method to keep the table
synchronized? How much load will replication added to the sql server? |