Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

I have been told that we can greatly reduce our processing times by rebuilding our 2000 cubes in 2008. I was told the difference is substantial (2hrs down to 20mins).

Is this true? If so, why?

share|improve this question
4  
Too many imponderables to give a definitive answer, but SSAS 2005 and later are much, much better products than SSAS 2000. Plus, SQL Server 2000 is deprecated so you really ought to look at migrating off it anyway. – ConcernedOfTunbridgeWells Apr 13 '12 at 9:57

1 Answer

up vote 1 down vote accepted

Performance usually improves from version to version of SQL Server. SQL Server 2000's Analysis Services was nowhere near quick.

As to why - Microsoft doesn't give us the source code so it's a little tough to analyze that. ;-)

Like @ConcernedOfTunbridgeWells pointed out in his comment, though, the real reason you should get off SQL Server 2000 is that it's out of support.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.