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: Performance
I was messing around while at #sqlsat275 with Mark Stacy (blog) and Glenn Berry (blog)with a goal to benchmark some Azure images to see if different VM’s had different performance profiles CPU and memory speed in the Amsterdam data centre. We used geekbench which is available here: http://www.primatelabs.com/geekbench The initial conclusion is that while there … Continue reading Tip: Getting the good hardware in Azure