AnalysisServices Profiler Tracing

There are 2 entries for the tag AnalysisServices Profiler Tracing
SSAS: Exporting MDX from Profiler part 2
Greg Galloway commented on the previous post I made about exporting captured MDX queries from SQL Profiler, indicating that there was an issue with using the MDX cap Greg has posted an issue on connect which you can vote on here, but I can't see this behaviour changing in the near future. Maybe in Katmai they could make the extract smart enough to do the parameter replacement as it creates the .mdx file. As far as I am aware the Analysis Services provider in SQL Server Reporting Services (SSRS) 2005 ......

Posted On Wednesday, July 4, 2007 7:57 AM | Comments (5)

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. 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 ......

Posted On Monday, July 2, 2007 7:17 AM | Comments (1)