When you need to do load testing for Analysis Services its common to need to capture and “replay” MDX queries. I’ll go into replay tools later – the first step is to capture the queries. You will need An XMLA trace definition file capturing at a minimum the QueryBegin and QueryEnd events (Events 9 and … Continue reading Capturing a Service Side Trace for MDX<
Category: Analysis Services
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 !