Browse by Tags

Analysis Services 2000 & 2005 on same server?

Published 10 May 7 3:39 AM | SqlServer-QA.net (SSQA)

Can we handle SQL Server Analysis Services 2000 and 2005 versions on the same server? Yes it is possible, but in the real sense you have to more careful to attain the performance by having a high-end specificiation hardware to cope up the pressure. Theoritically...

Filed under: mdx, analysis, microsoft, server, machine

MDX query performance issues in SQL 2005 Analysis Services

Published 6 May 7 5:20 AM | SqlServer-QA.net (SSQA)

See the relevant KBA resources here: When you run an MDX query in SQL Server 2005 Analysis Services, the query takes longer to run than expected http://support.microsoft.com/?kbid=935995 An MDX query takes longer than you expect to finish in SQL Server...

Filed under: performance, mdx, analysis