SSAS: Exporting MDX and XMLA from SQL Server Profiler

Hey, why didn't anyone tell me about this one? :)

I was not looking for this, I was looking for someway to easily extract event durations without having to get my hands dirty with angle brackets (XML) and I stumbled upon the menu below.

image

It appears that you can easily extract "MDX Events" or "All Queries" to an .mdx file. Notice that there is also one for Extracting DDL events, so presumably you could extract the XMLA for a set of operations on the server or database so that you could wrap them up and reply them somewhere else. Could be a useful thing to tuck away in the old tool box.

Print | posted on Monday, July 2, 2007 7:17 AM

Comments on this post

# re: SSAS: Exporting MDX and XMLA from SQL Server Profiler

Requesting Gravatar...
Now if it only replaced parameter placeholders with the actual parameter values, that would be quite handy ;-)

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=285789
Left by furmangg on Jul 03, 2007 12:07 AM

Your comment:

 (will show your gravatar)