SSAS Cube Synch - which server's memory it will consume?

Question

Hi,

As I know there are 2 ways to synch the SSAS cube- 1. Manual way(via DB Synch wizard) 2. XMLA script which can also be automated.

I am using both ways randomly to synchronize the ssas cube from source server to destination server.

XMLA script is being executed via SSIS dtsx package in Source server and manual synchronization wizard need to trigger from destination server.

In both the cases, which server's memory(CPU utilization) it will consume - either source server or destination server?

Can you help or provide any reference please ?

---

Answer 1

The highest resource usage will be on the destination server. On the destination server it has to start a transaction, then merge in changes from the source database, then commit that transaction.

---

http://darren.gosbell.com - please mark correct answers

Answer 2

Apart from CPU utilization, in the aspect of Memory, I think the two server will consume relatively same RAM size, size they are two synchronized SSAS Cube.

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.