Report Portal

Identifying Top MDX Queries running in SSAS environment

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

Tags: mdx, performance

 

2007-2015 VidasSoft Systems Inc.