Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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

share|improve this answer
looks like it only show current activity – Scott Weinstein May 27 '10 at 15:27
@Scott: it looks like it pulls the user activity data out of $system.discover_sessions - perhaps you can use this to create your own store procedure that creates a history? – MattB May 27 '10 at 15:53
Indeed, a plan for the future – Scott Weinstein May 27 '10 at 15:57
I did something similar with sp_who to get a historical log of SQL Server connection activity. Basically I have a stored procedure that runs sp_who and parses the results into a table, as well as a job that runs the proc every 10 minutes. – MattB May 27 '10 at 22:46

yes you have two options for monitoring

setup the query log:

or run profiler:

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.