after upgrade to SQL Server 2008 spike on processing time in special regard to the indexes portion
Since the upgrade of our SSAS environment on SQL Server 2008 we have noticed a consistent increase on cube process time.
The picture below shows the time spent during process executing using the two version of SQL Server meanly 2005 and 2008.
For your convenience I have attached the excel document that the pictures was derived from; as well as the xmla scripts that is used to process the indexes.
We would like to know what could have caused such a spike on processing time in special regard to the indexes portion.
Upvotes: 1<=-=Jul 25 2008 11:07AM=-=>
Thanks a lot for reporting the problem.
It is very hard to diagnose it without having exact repro in-house.
We suggest you work with Product support to setup a scenario for us to be able to debug and figure out what is happening.
The Analysis Services Team.