You are given a cube you have never seen before and need to make it process faster – where do you start ? Do we add indexes to the data warehouse, add faster disks, delete some aggregations, add more memory, or start messing the the “INI” files ? I would say none of the above! While there … Continue reading Tool for baselining MOLAP Processing
Tag: MOLAP
When reviewing design or performance of a MOLAP analysis services database we need to determine where the space. Common problems are: We have too many or too large aggregationsIf we have too many bitmap indexesLarge attributes with string or binary data in themIf some fact tables are growing too much. The only real way to … Continue reading Disk Space Analyser for Analysis Services (MOLAP)