Hello Can anybody tell me what extra performance ASAS 2005 (SQL server 2005) gives compared to 2000? The question only regards software not hardware. The scenario is that we have to servers with the same hardware (with more than minimum requerements for SQL 2005 - not 64 bit). On server one we install SSAS 2000 and on server two SSAS 2005. We must be able to get the same information through the cubes on both servers. This question also regards the following statement from Microsoft: "OLAP user experience is directly correlated to the query performance. As noted, there are two factors that contribute most to the SSAS efficiency â€” the optimized query engine and the cube multidimensional model. SSAS 2005 brings additional performance enhancements. Most of them are related to the fact that SSAS 2005 cubes are not limited to having one fact table anymore. What this means to you is that you don#%92t have to use virtual cubes anymore. Another cause of grievance in the past was that SSAS 2000 required all dimensions to be loaded in memory. To address this issue, SSAS 2005 loads dimensions in memory on as-needed basis." This means than on server with SSAS 2005 we will have fewer but larger cubes which should enhance performance. Can this extra performance be quantified (perhaps a benchmark)? Thanks in advanced.