Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein

Friday 1 June 2012

Cube Synchronisation Scale Out Methods

There are 4 Analysis Services Synchronisation Methods
  • Analysis Services Synch Method
  • Backup/Restore Database
  • Attach/Detach Database
  • Robocopy Method
You can read more after the Querying and Processing cubes for scale out section


Synchronize Analysis Services Databases

Other useful articles for scaling out Analysis Services are

REAL PRACTICES: Performance Scaling Microsoft SQL Server 2008 Analysis Services at Microsoft adCenter

Scale-Out Querying with Analysis Services
http://sqlcat.com/sqlcat/b/whitepapers/archive/2007/12/16/scale-out-querying-with-analysis-services.aspx (download white paper http://technet.microsoft.com/library/Cc966449 )

Analysis Services 2008 R2 Performance Guide
Design Patterns for Scalable Cubes
Tuning Query Performance
Tuning Processing Performance
Special Considerations

No comments:

Post a Comment

Note: only a member of this blog may post a comment.