Brief Problem Description: MSAS Cube synchronization under 10 MB/sec.
We run more than 20 servers supporting Microsoft SQL Server and Analysis Services.
In all cases the operating systems is 2008 R2 enterprise.
The systems are all modern 64 bit with 64GB to 256GB of main memory.
Servers have dual “teamed” 1 Gb/s network connections.
We implement the concept of a staging server and a live server.
On the staging server the MSAS cube is regularly updated from the local SQL Server DB. The live cube server is then synchronized from the staging cube. Users only go against
the live cube.
View Complete Post