I am facing a unique problem. we have three environments setup for datawarehouse dev,testing,production. we have our own customized application to process cubes. When I process the cubes in dev it is fast when compared to QA environment and QA is faster than prod. I conducted a test in all these three environments with same rows of fact table and dimension members. The only difference is dev Analysis Manager db size is 1 GB, QA has 35 GB and Prod has 55 GB of data. The data has been split into many partitions. The processing of 6 million rows in fact table takes 15 mins with 12 dimensions in prod where as in dev it takes 6 mins. Any idea why cube processing is slow in QA and Prod while faster in dev.