SQL Centre of Excellence

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

http://blogs.msdn.com/b/pfebi/archive/2013/02/12/managing-server-side-analysis-services-profiler-trace.aspx

blog comments powered by Disqus

Page List

Page List