locked
Usage Tracking in SSAS Tabular Project RRS feed

  • Question

  • Hi All,

    We have a SSAS 2017 tabular model which we are using for Power BI.

    We want to track the number of users who are hitting the tabular model without impacting the load on the prod server.

    What is the best way to track this ?

    We want the data to be real time without any lag.

    Regards,

    Akash

    Monday, May 14, 2018 7:09 AM

Answers

  • Hi Akash,

    Thanks for your response.

    >>>Is there any impact of server performance with this approach ? And will it give real time data ?

    Yes, it might effect server performance, but it will give you real time data stored in the SQL Server table.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by akj2784 Tuesday, May 22, 2018 1:16 PM
    Tuesday, May 22, 2018 9:24 AM

All replies

  • Hi Akash,

    Thanks for your question.

    >>>We want to track the number of users who are hitting the tabular model without impacting the load on the prod server.
    It is impossible to track the Usage of a SSAS 2017 tabular model without impacting the load on the prod server. Tracking the Usage of a SSAS 2017 tabular model will impact the performance on the prod server more or less.

    >>>What is the best way to track this ?
    I would suggest you to use SQL Profiler Trace, save trace results to a SQL Server table, then you can get the information from that stored table.
    https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/save-trace-results-to-a-table-sql-server-profiler?view=sql-server-2017


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Proposed as answer by alexander fun Tuesday, May 15, 2018 8:09 PM
    Tuesday, May 15, 2018 1:58 AM
  • >>>What is the best way to track this ?
    I would suggest you to use SQL Profiler Trace, save trace results to a SQL Server table, then you can get the information from that stored table.
    https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/save-trace-results-to-a-table-sql-server-profiler?view=sql-server-2017

    Is there any impact of server performance with this approach ? And will it give real time data ?

    Tuesday, May 22, 2018 8:51 AM
  • Hi Akash,

    Thanks for your response.

    >>>Is there any impact of server performance with this approach ? And will it give real time data ?

    Yes, it might effect server performance, but it will give you real time data stored in the SQL Server table.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by akj2784 Tuesday, May 22, 2018 1:16 PM
    Tuesday, May 22, 2018 9:24 AM