Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers 2

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
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

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.