Avatar of Bodhi108
Bodhi108
 asked on

SSAS - Sql Server Analysis Server Cube Performance question

I am working with SSAS and trying to figure out why our processing the cube on Production takes 3 times as long as the cube on Test.

Similarities and DIfferences
Data Warehouse - data in warehouse is identical.
Cube - almost identical.  Test has a few extra columns exposed in the cube.
Database - both run on SQL Server 2008.
Operating System - Production - Datacenter Service Pack 1
                                Test = Windows Server 2003 R2, Service Pack 2
RAM - both have 8 GB
Processors - Production -3.20GHz
                    Test - 2.33GHz
                    Both have 2 processors

64-bit - both are 64-bit Operating Systems.

What else could be the difference?

Thanks,
Abbi
Microsoft SQL Server 2008SSAS

Avatar of undefined
Last Comment
liija

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
liija

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61