Analysis Services Hangs | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Analysis Services Hangs

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
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.
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 .

Check there is no blocking while reading the data from the database and make sure you have enough memory… Chapter 26 – Performance Tuning Analysis Services
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part6/c2661.mspx?mfr=true
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

]]>