So you’ve got a BI solution up and running and want to find out what MDX queries are actually running on your server?
Well this guide will help you quickly find out.
Step 1: – Launch SQL Profiler – You can find it on the Tools menu of SQL Server Management Studio (SSMS):
Step 2: – Login to Analysis Services:
Step 3: – Start a new Trace:
Step 4: – Remove a lot of the noise by removing all the events you don’t care about:
Just leave the ‘Query End’ event ticked.
If your server isn’t very busy then you can probably just click ‘Run’ to start profiling, otherwise continue onto the next step.
Step 5: – Filter the traces even more
Before clicking ‘Run’ you can do some more filters by clicking on the ‘Column Filters’ button.
Step 6: – Show queries for only a specific user
Here I’m adding a filter to only show results where the NTUserName = grudman ( grudman is my username)
Step 7 – Click run, and watch the trace logs come in 🙂
Step 8 – Optionally create a template for all this
Please see my next article for the steps you’ll need to perform
As always all feedback is welcome 🙂