Report Portal

Tool for baselining MOLAP Processing

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 are lots of resources on the internet with tips for improving processing time, the best place to start is with a "baseline". E.g. we need to understand how long the Analysis Services database takes to process and more importantly where time is being spent and why. Once we understand this we can focus in on a specific area and re-baseline to see improvements in that area.

Read more...

Tags: management, process

 

2007-2015 VidasSoft Systems Inc.