locked
SSAS Tabular report for User Queries log RRS feed

  • Question

  • Hi ,

    I want to extract a report based on the queries my users are running against the tabular model. The users are connecting to tabular model from excel sheet and applying different filters for running the report.

    What is the best way to trace this on the production Analysis server.  Based on this report I want to find out which filters applied by the user are taking long time for extracting the details. Are there any logs stored for the user queries.


    Tuesday, September 6, 2016 1:59 PM

Answers

  • Hi

    There is no log that collects this information by default however you can create something similar . There are a few options available to you.

    Profiler: Works well if you want a quick look at what queries are running and how long they take to complete. Profiler can add a bit over overhead to the server so probably not something you would want to run on production or at least for an extended period of time.

    Extended events : Are the "new" way of gathering SQl Server stats. Its harder to setup (On UI) but is far less resource intensive and may also be left running under the right circumstances (Please test first).

    Other links that will help: 

    https://blog.crossjoin.co.uk/2016/04/18/profiler-extended-events-and-analysis-services/

    http://markvsql.com/2014/02/introduction-to-analysis-services-extended-events/


    Tuesday, September 6, 2016 5:15 PM