Home / server / Questions / 145872
In Process
Scott Weinstein
Asked: 2010-05-28 06:02:34 +0800 CST

Is it possible to determine the top users of SqlServer analysis services?

  • 772

We're trying to figure out how many licenses we need of a desktop data analysis package which connects directly to our SSAS instance.

I'd like know if it's possible to query the history of connection or queries by user so we can determine who is actively using the software.

I've looked into $system.DISCOVER_SESSIONS, but it seems that it only contains current sessions. I'd like get historical activity.

Any ideas?

sql-server sql-server-2008

2 Answers

  1. I've never used it, but Microsoft has an activity monitoring tool for SSAS 2008 out on CodePlex.

    • 0

  2. yes you have two options for monitoring

    setup the query log: http://technet.microsoft.com/en-us/library/cc917676.aspx

    or run profiler: http://msdn.microsoft.com/en-us/library/ms174779(v=SQL.90).aspx

    i would recommend trying both and seeing which one works best for you.

    • 0