SSAS Multidimensional 2012 Deployment


  • I am new to this. So far I use visual studio 2012 and hit deploy button (after dropping the target database if it exists since I only do full deployments). I see they recommend to process data and indexes seperately, but I do not know how to do that and be able to time it etc. Currently I look at the duration results from "Deplyoyment Progress" in visual studio and I also have sql trace for sql server and analysis services. Currently the full deploy takes about 52-70 minutes and analysis services multidimensional database estimated size is 36639.75 MB. I have 8 partitions and during 95% of the duration all 8 processors available are at 100% which supposed to be good (I hope)

    How do I deploy (process data and indexes etc) in stages, what tool do I use etc, is there a sample or a tutorial for it so that I can easily figure out the bottlenecks etc?

    Thank you

    Gokhan Varol

    Sunday, July 28, 2013 6:21 PM


All replies