Its hard to do capacity planning for MOLAP cubes and a common question asked is if we have enough memory or why the server is showing zero bytes free memory wise. While the msmdsrv.exe process can consume a lot of memory between the storage engine cache and formula cache, we need to be super careful to ALSO … Continue reading You need more memory than you think for MOLAP !
Its no secret that optimising distinct count in SSAS/MOLAP is painful. the normal optimisation stuff is covered in various papers such as: - INI file settings to increase PageSize - Separate Measure Groups - Trying to partition by the distinct count item so that each partitions min and max values don't cross over. We recently … Continue reading Progress Report Flooding with Distinct Count MOLAP