Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Performance Tuning SSAS 2008 Webinar

with 4 comments

I probably should have mentioned this a while ago, but on Thursday at 8-9pm GMT (which is 3-4pm EST) I’m doing a webinar for the guys at Pragmatic Works, on “Performance Tuning Analysis Services 2008″. It’s going to be a basic-level introduction to the subject, covering topics such as partitioning, aggregations and MDX calculations. You can sign up here:
https://www1.gotomeeting.com/register/824246961

 

 

Written by Chris Webb

November 16, 2010 at 1:32 pm

Posted in Events

4 Responses

Subscribe to comments with RSS.

  1. Hello Chris,
    I have missed this. do we have a chance to watch

    Erdem Zengin

    January 27, 2011 at 7:36 am

  2. It should be, but I can’t find it. You can see pretty much the same presentation here:

    http://content.sqlbits.com/Sessions/Event6/Introduction_to_Performance_Tuning_Analysis_Services_2008

    Chris Webb

    January 27, 2011 at 8:43 pm

    • Hi Chris ! Good Day!

      I need your inputs/suggestions regarding performance tuning of cubes. Currently I am facing a lot of issues w.r.t performance of SSAS cubes in my project. The design of the cube is pretty simple and straight forward. There are no M2M relationship or reference relationship in my Dimension usage. However we have written a lot of SCOPE statements to meet the business requirements.

      My issues are the reports take a lot of time to open up. We are using Panorama for Adhoc analysis and any kind of cross drill on the dimension or any drill down from a higher lever to the lowest level directly takes a lot of time in rendering the data.

      I have done my initial bit of analysis and I ran the UBO. I enabled the Query logging for a Month and I ran the UBO and the aggregations were designed as per the suggestion by the wizard. However when I try to process the cube with the new Aggregations, My cubes are failing because the new aggregations are consuming a lot of disk space and I get the File system error stating that there are no enough space on the disk.

      Please let me know where am i going wrong. I am now considering to create partitions and then try out the UBO options.

      Could you please let me know the best approach in resolving this issue?

      Thanks a lot !

      Regards,
      Ram

      Ram

      November 30, 2012 at 11:27 pm

      • Hi Ram,

        First question: are the Scopes causing your problems? Try deleting all your aggregations and then commenting out everything in the MDX Script and reprocessing, then run your queries. Is everything fast?

        As far as the aggregations go, if you are running out of disk space you either need to delete some aggregations or get more disk space! To be honest it sounds like you’ve built too many aggregations, so I would try rerunning UBO but building no more than 10-20 aggregations (try limiting Performance Gain to around 30%).

        Chris

        Chris Webb

        December 1, 2012 at 2:35 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,190 other followers

%d bloggers like this: