dbTalk Databases Forums  

Is replication a good solution?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Is replication a good solution? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
nick
 
Posts: n/a

Default 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?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.