asked
SSAS Cubes User Activity
Is it possible to join SSAS activities based on different DMV Tables? Scenario: Joining $system.DISCOVER_SESSIONS with $system.DISCOVER_Commands Example: select $system.SESSION_ID, $system.SESSION_SPID, $system.SESSION_USER_NAME, $system.SESSION_CURRENT_DATABASE, $system.SESSION_START_TIME, $system.SESSION_ELAPSED_TIME_MS, $system.SESSION_LAST_COMMAND, $system.SESSION_LAST_COMMAND_CPU_TIME_MS, $system.SESSION_COMMAND_COUNT, $system.COMMAND_START_TIME, $system.COMMAND_TEXT, $system.COMMAND_END_TIME FROM $system.DISCOVER_SESSIONS INNER JOIN $system.DISCOVER_Commands
I haven't done this specifically, but try *Use Dynamic Management Views (DMVs) to Monitor Analysis Services* on MSDN -
http://msdn.microsoft.com/en-us/library/hh230820.aspx
15 People are following this question.
