ran.ovadia (3/25/2015)
Hi,I'm syncing OLAP DB every day from the backend server which process the cube to the frontend.
The cube size is 100 Giga.
The problem is that sometimes the sync time is 30 min and sometimes 2 hours.
Can any body help me understanding the difference?
In addition to that, is there any best practices document for SSAS (2008 R2)?
Thanks,
Ran.
It could be any number of things, from resource contention on the database server to maintenance tasks or fragmented indexes.
I'd recommend that you start by look at what else is happening at that time, then work your way towards looking at the specific queries being executed against the back-end server and the actual processing of the cube itself. A process of elimination usually works best.
For SSAS 2008 R2 best practices, see the following whitepaper: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=17303