Solved

SSAS - Sql Server Analysis Server Cube Performance question

Posted on 2013-02-06
1
429 Views
Last Modified: 2016-02-18
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
0
Comment
Question by:Bodhi108
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
liija earned 500 total points
ID: 38862825
For example:
- SQL Server memory settings
- SSAS memory settings
- SQL Server index fragmentation
- SQL Server indexes - are the indexes identical in both DW's? Could affect if you have complex DSV in your cube.
- Server hardware, storage of SQL server databases?

You could run SQL Profiler on both of the machines when processing the cube, check the actual SQL queries run -  and compare the performance on both servers.
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question