?
Solved

SSAS - Sql Server Analysis Server Cube Performance question

Posted on 2013-02-06
1
Medium Priority
?
447 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 2000 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

764 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