SQL Server Performance Forum – Threads Archive
Analysis Services HangsI 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
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.
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
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.