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

SSAS 2008 - INI Files and in place upgrades
24 September 2009 22:13

Being the suspicious person i am i wondered if there would be any differences in the MSMDSRV.ini of an instance upgraded from 2005 as opposed to a clean install. Now obviously i expect an in place upgrade to preserve my settings and add any new ones because it should not overwrite anything since i might have change from defaults for a good reason……. Below is... Read More...

by ACALVETT | with no comments

Filed under: Tips, SSAS 2005, Analysis Services, SSAS, 2008