Browse by Tags

Enter the SSAS server level lock......
23 November 2009 18:13

Ok, so your reaction to the title is probably the same as mine when i found out about SSAS server level locks! So, i will give you the scripts to reproduce the server level lock but first lets get down to business…. :) Server locks were introduced in one of the SP2 cumulative updates. At the moment i can say it was pre CU12. I`m not sure why it was introduced... Read More...

by ACALVETT | 1 comment(s)

Filed under: Tips, Performance, SSAS 2005, Analysis Services, Hanging, SSAS, Locking

Analysis Server appears to hang…..
05 April 2009 21:40

We had an ongoing problem where by users would suddenly start complaining that the Analysis Server was hanging. When investigating the box we could see that there appeared to be no physical constraints. Disks were a bit above average, CPU was very low and there was plenty of memory. When looking at the server through the SSAS activity viewer (part of the community... Read More...

by ACALVETT | 1 comment(s)

Filed under: Performance, SSAS 2005, Analysis Services, MDX, Hanging