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

The cost of SSAS metadata management
21 August 2009 06:45

This post will explain how we found ourselves in a situation where when processing a partition the metadata checks took 50 times longer than the actual partition and how to identify what time penalty you are incurring for the metadata checks. The system i was investigating had around 80 cubes with around 100 partitions per cube all hosted in one database and... Read More...

by ACALVETT | 2 comment(s)

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

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

Changing the Data Files Location after Installation
10 August 2008 10:28

The other day i wanted to change the "Data Files" location for a 2005 database engine installation and a 2005 Analysis Services installation which you can specify under the advanced options during installation. I quickly found out that there appears to be no documented ways to do this other than uninstall SQL Server and install again specifying a new... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, Tips, Analysis Services, Database Engine

SSAS 2005 – Server side tracing starter kit
07 April 2008 22:32

Analysis services 2005 (SSAS) added the ability to trace server side events and i have used this feature a number of times. To date i had always used the profiler gui to do the SSAS tracing but today i found myself needing to initiate and manage a trace with scripts. The good news is that it can be done! It did take a while to piece together how to do it though... Read More...

by ACALVETT | 1 comment(s)

Filed under: Tools, Tips, Performance, SSAS 2005, Analysis Services