Identifying Top MDX Queries running in SSAS environment
User Rating: / 2
PoorBest 
Written by Parikshit Savjani   
Thursday, 24 May 2012 19:26

SQL Server has management studio reports, performance dashboard reports to identify top cpu, duration, io queries which is possible due to the DMVs viz sys.dm_exec_query_stats which is available to track the queries.

However with SSAS, we do not have any DMV similar to sys.dm_exec_query_stats which tracks and captures the statistics of the queries fired against SSAS cube. In this blog post, I would discuss on how we can achieve something similar with SSAS.

Read more...

 

 

Pyramid Analytics