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: mdx
Bitmap Indexes (*.map files) play an important role within Analysis Services. They provide a mechanism for the storage engine sub cube event to efficiently locate the relevant segments within the fact file without having to scan the whole thing. This is how you can have a 20 GB *.fact file in the partition but still … Continue reading How to turn off/on bitmap indexes in SSAS