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
ASKER CERTIFIED SOLUTION
Avatar of liija
liija
Flag of Finland image

Blurred text
THIS SOLUTION IS 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
Microsoft SQL Server 2008
Microsoft SQL Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.

50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo