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 10)
- AN XMLA command to end the trace
- The ASCMD.EXE utility to automate the starting/stopping of the trace. The utility is available here
http://msftdbprodsamples.codeplex.com/downloads/get/384553
Here’s a quick video demonstrating the process of capturing a trace and importing the results into a data table.
More details on managing server side traces are also provided on this link here