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?
Sql-server – SSAS 2000 vs 2008 Cube processing times
sql-server-2008ssas
Related Question
- Sql-server – SQL Server 2000 to SQL Server 2008 linked server issue
- Sql-server – Why does an AS cube rebuild use so much TempDB
- Sql-server – SQL Server 2000 to 2008 to 2012
- Sql-server – How to check the health of a SSAS database? And of its backups
- Sql-server – SSAS cube process time increased after making fact and dimension small
- Sql-server – Processing cube freezes SSAS
Best Answer
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.