Anyone have tips or information on techniques for obtaining and interpreting SSAS cube usage stats? I have been using SQL profiler to capture stats but it has been challenging to interpret and determine what is useful. Simply need user stats on queries run, when accessed, duration, CPU, and cubes/databases accessed. Thanks!
There are several DMVs pertaining to SSAS that will give you this information. If you look at Using DMVs with SSAS it will provide a good overview on what and where to collect the data that you are looking for. You could set these up to run at an interval and capture the data for historical analysis. IDERA also has a product called BI Manager that captures all the information that you listed as well as keeps it for a period of time to run reports or statistical analysis on.
Hi Stan, Thank you for the information. This is helpful, however, i'm looking to obtain more in depth user query stats - historical by day. Looks like the DMV's provide info on current live connections but no details on individual queries.
I think that's the point of the product mentioned, to collect, archive, and aggregate the information from the DMVs.
Powered by IDERA