Browse by Tags

SQL Agent and SSAS Commands
30 May 2011 15:27

SQL Agent can be used to execute SSAS commands such as processing of a dimension and i can see that it is useful when you want to quickly schedule an adhoc processing task but there is a major drawback you need to be aware of. You are not able to specify the database to connect to and whilst you may think that it does not matter because the database is specified... Read More...

by ACALVETT | with no comments

Filed under: Tips, SSAS 2005, Analysis Services, SSAS, 2008, Locking, SSAS 2008 R2, 2008 R2, Blocking, Default Database, Processing, SQL Agent

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 | 5 comment(s)

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