SQL Server Performance

Analysis Services Hangs

Discussion in 'Analysis Services/Data Warehousing' started by PoojaB, Apr 12, 2007.

  1. PoojaB New Member

    I have a set of Analysis Services 2000 cubes that are refreshed every week.Each week theres a huge increase in data.So I placed filters on the major dimentions and the partitions.Still the cubes fail to process.Analysis Services hangs while paocessing one of the large dimentions[<img src='/community/emoticons/emotion-6.gif' alt=':(' />].On the production server condition is so bad that now I am unable to even save the cubes after making changes[xx(].Analysis Services simply hangs when i try to save the cubes.Somtimes when i click on save it gives the message "Unable to Save" [xx(][xx(].Even after i restart MSSQLServerOLAPService there is no improvement.Can someone help with this.<br /><br />Thanks,<br />Pooja
  2. satya Moderator

    What is the service pack on the SQL instance?
    http://support.microsoft.com/kb/295537 fyi.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. PoojaB New Member

    Thanks Satya.
    Well the version of analysis services 2000 is SP3/3a.I will be installing SP4 which is the latest version soon.
    Will installing the new version be helpful.
    I know it does fix some processing issues.
    Is there any other way i can improve performance .
  4. MohammedU New Member

Share This Page