Go Back   CORTEX Forums > Local Happenings > CORTEX Blogs > Random Procrastination
Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read

SSAS 2008 R2 – Improvements for slow Metadata

This is a discussion on SSAS 2008 R2 – Improvements for slow Metadata within the Random Procrastination forums, part of the CORTEX Blogs category; There was a thread last year on the SSAS MSDN forum SSAS 2008 -- Why is metadata so slow??? in relation to slow metadata queries on a cube with 250+ ...


Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 8th February 2010, 11:27 PM   #1
Member
 
Join Date: Jun 2009
Posts: 47
Darren Gosbell is on a distinguished road
Thumbs up SSAS 2008 R2 – Improvements for slow Metadata

There was a thread last year on the SSAS MSDN forum SSAS 2008 -- Why is metadata so slow??? in relation to slow metadata queries on a cube with 250+ measure groups. The good news is that despite the fact that the SSAS team has largely been focussed on PowerPivot for the SQL Server 2008 R2 release, they have also tried to address a few of the customer pain points in SSAS. Below is part of a recent response to this thread from Akshai Mirchandani from the SSAS development team:
"As an update to this discussion, we did implement an improvement to the way this EstimatedSize property works in the upcoming SQL Server 2008 R2 release -- the latest CTP includes this change. It would be great to hear from any of you who can try this out to see what the impact is on the performance in real-world situations.


This change does require you to update all your partitions and dimensions in some way -- the server will persist the estimated size of those objects at that point and not require scanning their file sizes every time you discover metadata. ProcessUpdate on the dimensions and ProcessClearIndexes+ProcessIndexes on the partitions should do the trick. Without updating the dimension/partition objects things will still work, but without the performance gain...*
Additional note: due to these types of changes, you may not be able to take a 2008 R2 database downlevel to a 2008 server.


As most of you have probably heard, AS 2008 R2 is primarily targeted at the self-service user with the new PowerPivot solution -- but we've tried to tackle a few of the pain points for our existing customers along the way. Some examples:

  • This discovery of metadata issue
  • Processing of a single (typically small) partition in the context of a very large number of metadata objects (e.g. 1000s of partitions) should now be significantly quicker. The algorithm that analyzes dependencies was optimized for this scenario.
  • Also, R2 now supports calculated members in subselects -- and the new Excel 2010 pivot tables will let you make use of that feature."
If are having issues with slow metadata for a large database/cube then it would probably be worth giving the November CTP of SQL 2008 R2 a try. If you have any feedback for this issue feel free to post a comment either here or on the original forum thread.






Get More from the original blog...
Darren Gosbell is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Metadata admin M - O 0 26th January 2010 05:16 PM
PreP+07: improvements of a user friendly tool to preprocess and analyse microarray da admin Analytic News Feeds 0 18th November 2009 12:38 PM
Metadata Management Jane B Data Integration Forum 3 4th November 2009 10:13 AM
SQL Downunder 2009 Presentation: SSAS Metadata – Knowledge is Power Darren Gosbell Random Procrastination 0 11th October 2009 08:31 PM
Slow Business Intelligence Steve Bennett Oz Analytics 0 10th June 2009 01:46 PM


All times are GMT +11. The time now is 09:30 PM.

© The Business Intelligence Group

Search Engine Optimization by vBSEO