|Identifying Top MDX Queries running in SSAS environment|
|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...