SSAS Cube Synch - which server's memory it will consume? - SQL Server Analysis Services
SSAS Cube Synch - which server's memory it will consume? - SQL Server Analysis Services
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 ?
SSAS Cube Synch - which server's memory it will consume? - SQL Server Analysis Services
SSAS Cube Synch - which server's memory it will consume? - SQL Server Analysis Services
""SQL Server related"" forum will be migrated to a new home onMicrosoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home onMicrosoft Q&A SQL Server!
For more information, please refer to the sticky post.
SSAS Cube Synch - which server's memory it will consume? - SQL Server Analysis Services
SSAS Cube Synch - which server's memory it will consume? - SQL Server Analysis Services
""SQL Server related"" forum will be migrated to a new home onMicrosoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home onMicrosoft Q&A SQL Server!
For more information, please refer to the sticky post.