SQL Server Performance

Cube processing performance

Discussion in 'Analysis Services/Data Warehousing' started by mohankumar, Feb 24, 2007.

  1. mohankumar New Member


    I am facing a unique problem. we have three environments setup for datawarehouse dev,testing,production.

    we have our own customized application to process cubes. When I process the cubes in dev it is fast when compared to QA environment and QA is faster than prod.

    I conducted a test in all these three environments with same rows of fact table and dimension members. The only difference is dev Analysis Manager db size is 1 GB, QA has 35 GB and Prod has 55 GB of data. The data has been split into many partitions.

    The processing of 6 million rows in fact table takes 15 mins with 12 dimensions in prod where as in dev it takes 6 mins.

    Any idea why cube processing is slow in QA and Prod while faster in dev.
  2. ranjitjain New Member

    Are there any machine config differences?
    for eg: Processor,RAM.
    Also check the OS version and Analysis server service pack level?
  3. mohankumar New Member

    Thanks for replying..Below are the details....

    Dev and QA db are on the same machine.

    DEV and QA Environment
    ======================

    OS : Windows 2000
    RAM : 4 GB ( 3 GB swtich not enabled)
    Analysis Server Service pack level : sp4
    Data stored in local hard drive
    CPU's : 4


    Prod Environment:
    ==================

    OS: Windows Server 2003
    RAM : 4 GB (3 GB Switch enabled)
    Analysis Server Service pack level : sp4
    Data stored in sans drive
    CPU's : 4

Share This Page